do until end of list
Hi! I have a long list in a spreadsheet. In my macro I want to loop through
that list and do series of operations as long as I have not reached the end
of my list. I am having some trouble with my code. The thing is that it
depends on which computer I am running the code on. On my computer it works
fine but the other computer gives error: Object required.
The simple loop I am trying to make is:
Set nameCell = Range("b9")
Do Until IsEmpty(nameCell.Offset(i, 0))
i = i + 1
Loop
As far as I know I have the same Excel version. Please help me with this!
Thank you very much!
|