View Full Version : Solved: help looping through columns

11-11-2008, 01:49 AM
thanks for the help in advanced....

ok, so if i wanted to loop through rows 1 - 10, i would do something like
for x = 10
' do something
next iLcv

how the hell do you loop through columns? say A-Z ?

more specificly, am trying to change the value in an address such as
sheet3.range("A" & iLcv)
but i need to make the Column the varable....

thanks again

11-11-2008, 02:03 AM
ok, i finally figured it out....seems i was barking up the wrong tree.....

i should have been looking at the CELLS(x,y) function where x=row and y=column.