I want to select columns using a variable i, which is the first blank column whose number I get from a loop.
How can I then say to copy some columns and paste them in columns i to i+3
I want to select columns using a variable i, which is the first blank column whose number I get from a loop.
How can I then say to copy some columns and paste them in columns i to i+3
[vba]
Columns(i).Resize(,2).Copy Columns(i+3)
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber