Consulting

Results 1 to 2 of 2

Thread: Solved: help looping through columns

  1. #1

    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

  2. #2
    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
  •