PDA

View Full Version : Solved: selecting columns using a variable



philfer
01-10-2008, 12:25 PM
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

Bob Phillips
01-10-2008, 02:22 PM
Columns(i).Resize(,2).Copy Columns(i+3)