What causes this runtime 424 "Object Required" error?

[gers1978]

I have some code and one of the subs contains this line:

Do Until Sheet1.Range("A" & Row).Value = vbNullString

It works flawlessly.

However I now want to run this code on a different sheet, namely one called "Invoice". So I changed the code too:

Do Until Invoice.Range("A" & Row).Value = vbNullString

However now when I run it, I get a runtime 424 error, "Object Required".

If I change it to:

Do Until Worksheets("Invoice").Range("A" & Row).Value = vbNullString

again, it works fine.

Can anyone tell me what's going on, and why sometimes you need to use "Worksheets("<name>")" format and sometimes not?

Thanks!

Also posted here: http://www.ozgrid.com/forum/showthread.php?t=197330&p=759134#post759134

 

[shg]

Are you making this up?

There's no "Modules" in the object browser.

EDIT: Modules.Add appears to just add a code module.

 

[RoryA]

Are you making this up?

For once, no.

EDIT: Modules.Add appears to just add a code module.

Yes, but check Sheets.Count before and after you use Modules.Add.

 

[shg]

Curious.

Does it have any surviving utility?

 

[RoryA]

It gives you some ability to add code without going via VBProject so you aren't subject to the Trust Center security setting, I suppose.

 

[shg]

Huh. Another vestigial appendage.