Search results

Hi All I am trying to format text in a string. I receive this worksheet from third party and I have to print visiting cards using this information. Data received contains lot of formatting errors like upper and lower case, double space between words, which I cleared the most of it with the help...

can anybody pls help

Hi Chirayu thanks for the help I found this code below that works great for me. Only problem is I want to run this code on Sheet2 from commend button on Sheet1….. Private Sub CommandButton1_Click() Dim rng1 As Range Dim rng2 As Range Dim rng3 As Range Set rng1 = Cells.Find("*"...

sample file uploaded

Hi All I have data in “column D” in my work sheet, which is derived by formula and now I want to select a range of cells with VBA code in “column D” after the cell “D1” of the worksheet till the last row with the Real Value ignoring the cells with formula result “Blank” below the last Real value...

also need to apply same formula in each cell of "Sheet2 Column BB"

Yes I did press ENTER key after DELETE..

Hi...... no I just downloaded the file the put name (Mandar) in "sheet1 D4" and it worked then I delete name (Mandar) in "sheet1 D4" with delete key on keyboard but nothing happens..

Hi Vletm.... yes something like this.... but in this when I put filter it works and produce the statement i.e. dates between and name.. but when I remove filter (name) nothing happens.. Regards Mandar

Thanks Narayan for the help..

Hi Narayan thanks for throwing some light.... But unfortunately I am not good in vba... Can I get some solution??.. Mandar

Hi Narayan and Hui Sorry to confuse you, here is the whole concept in sample file. In this file I have Invoice data stored in sheet2 and in sheet1 I want to generate Invoice Statement based on filters (basic 5 filters) and we can make 23 combinations of these filters together to generate...

Hi All I have 23 combinations from column A to E and in column G…. I want to give each combination unique number. At present I am doing it with IF function and it's working fine as I am using office 2007 but it is too long and any small mistake can be painful. Is there any shorter way to do it...

Belleke's solution works great for me Thank you

Hi All I have a Excel file with open event which hides the application and show only user form but the user form is small in size. I want the form to open in Maximized State. any help? Regards Mandar

please help. I am new to VBA

Hi Everyone I am using a vba code to automate the process.. In which at the end I copy the last worksheet into new workbook and close the original workbook.. Now in this code I want to add one more step i.e. saving the new workbook at the same location of original workbook with the file name as...

Narayan what if the length of the input address is more then 72 characters Bosco's formula is also good but I don't understand the logic of 40 in it and again if the length of the input address is more; then what, please guide Regards Mandar

Hi Narayan K P.S. one more thing check the file Nr. Bus Stand, is repeated in every column. so I think some modification is needed in the formula...

Hi Narayan K it is ok even if Shanti Nagar is split as Shanti and Nagar, Logic needed is... it should split whole word till space... preferably the previous space so that the string will not go beyond the length of 35 characters... Mandar

Hi All I am trying to split the text string in to 35 characters in each line. And if the 35th character is in between a word the string should split whole word to the next column and in next column count 35 characters and again split for next column.. I am trying an array formula in first...

Thank you very much Hui.... Regards Mandar

Hui I tried the code but I get Run-time error '13': Type mismatch Regards Mandar

Hi all I am trying to generate the list from string values that are separated by comma in a range with the help of code But the problem is every time I have to change the code manually to get the desired list in desired column. Can it be done with single commend button click without changing...

Hi I tried technique suggested by Hui and successfully extract the data that is needed. But when the color is changed it is not updated automatically…. (the formula in column F and in cell N3 is not updated automatically) Regards Mandar