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!

Arne Hegefors wrote:
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!

Are you sure that there isn't something in the body of the loop which
is throwing the error? What is the actual line causing problems?

Also - earlier today in this group the topic of code working on one
machine but not another was raised. In that case, the underlying
problem was found to involve project references. Does your code invoke
an object from an external reference?

-semiopen

It is always worth checking on the faulty machine if there are any items in
ToolsReferences marked as MISSING. If so, uncheck them.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"semiopen" wrote in message
oups.com...

Arne Hegefors wrote:
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!

Are you sure that there isn't something in the body of the loop which
is throwing the error? What is the actual line causing problems?

Also - earlier today in this group the topic of code working on one
machine but not another was raised. In that case, the underlying
problem was found to involve project references. Does your code invoke
an object from an external reference?

-semiopen