Search results

Hi, i want to unwrap the text in vba, like for example below, I used the textsplit, it gives what i want, but its too many to do in the sheet, how can i do that in vba for whole sheet, thx

Hi, I want to delete the empty columns in my excel workbook, so i have found the coding in internet as follow, but i have 2 worksheets need to do the same macro how can i add one more worksheets in the coding below Dim col As Long With Worksheets("sheet1").UsedRange For col = .Columns.Count To...

Hi, I dont know VBA, but i am starting to know now, i follow your code to run the VBA, but i don't quite understand when u say, "Do not forget to update the sheet name in Set ws = ThisWorkbook.Sheets("Sheet1")." how can i dot that thx

Hi, is there any formulas i can so i will get the ABCDEF into the yellow column, I am trying to put the lastest version into the cell, for example, the first row has only A, so it will be A, but second row goes up to E, i need to put E in that cell thx