MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do you loop to the next column


Posted by Lino on February 11, 2002 6:39 AM

If I am analyzing a series of columns, when finished analyzing column 1 how do I loop to column 2?

Thanks

Lino


Posted by JohnG on February 11, 2002 6:46 AM

TRY
for x = 1 to (number of columns required)
cells(1,x).select
next x