VBA: Object variable or With block variable not set (Error 91) - ???

Posted to microsoft.public.excel.programming

Mac Lingo[_2_] Mac Lingo[_2_] is offline

external usenet poster

Posts: 53

VBA: Object variable or With block variable not set (Error 91) - ???

I am executing the following statement in VBA:

SetPtr = "Part 1"
Cells.Find(What:=SetPtr, _
After:=ActiveCell, _
LookIn:=xlValues, _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False, _
SearchFormat:=False).Activate

And I get the following message:
Runtime Error 91:
Object Variable or With Block Variable not set.

What does this mean?

Thanks,
Mac Lingo
Berkeley, CA

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Runtime Error '91' Object variable or With block variable not set	Alec Coliver	Excel Discussion (Misc queries)	2	October 24th 09 02:29 PM
Run-time error '91': "Object variable or With block variable not set	Mike[_92_]	Excel Programming	2	December 30th 04 10:59 AM
Error 91 -- Object variable or With block variable not set	Rachael[_3_]	Excel Programming	2	November 22nd 04 02:59 PM
Cells.Find error Object variable or With block variable not set	Peter[_21_]	Excel Programming	2	May 8th 04 02:15 PM
Error 91 - Object variable with block variable not set	Jim[_35_]	Excel Programming	2	November 27th 03 03:34 AM

All times are GMT +1. The time now is 05:15 PM.

Menu

About Us