I'm struggling to create the VBA to achieve the following...
Replace whatever text is in cells in a column with a repeated sequence of text values.
For example:-
Cell...
x1 = "Text1"
x2 = "Text2"
x3 = "Text3"
Then repeat...
x4 = "Text1"
x5 = "Text2"
x6 = "Text3"
Then repeat...
x7 = "Text1"
x8 = "Text2"
x9 = "Text3"
... and repeat until the end of data in cell xn (a blank cell).
Has anyone a clever piece of VBA code to achieve this please? Many thanks. F
Bookmarks