Use cells instead of Range of along with Range.

for ColCount = 1 to 26
cells(1,i).copy
next ColCount

or

for ColCount = 1 to 26
range(cells(1,i),cells(10,i)).copy
next ColCount

or

for ColCount = 1 to 26
Columns(i).copy
next ColCount




"jhong" wrote:

Hi,

Any suggestion would be of great help. I am doing a macro that will
lookup values from another sheet. Here's the scenario, from column B,
it will look up data from column A. My report is up to column Z, how
can I make a loop that will run from column B up to column Z.

What I did is I created a loop for each column, which is quite long. I
hope you have a better way in your mind :-)

Thanks in Advance!


Jerome