-
Solved: help looping through columns
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
-
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.
:-D
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules