View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arne Hegefors Arne Hegefors is offline
external usenet poster
 
Posts: 244
Default 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!