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, 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