Runtime error 91 Objecr Variable of With block variable not set

**s_ali_hassan** · 10-01-2010, 11:31 AM

Hi,

I'm hoping someone here can help with an irritating problem i am currently having in my macro.

I am trying to search for a value in a worksheet but i keep getting the 'Object variable or With block variable not set' error on the following line of code:

Please Login or Register  to view this content.

i have no idea why i am getting this error.

Anyone have any ideas how i can get around this.

Thanks!

**romperstomper** · 10-01-2010, 11:51 AM

You'd get that error if the find is unsuccessful. (you should never try and use the result of a Find on the same line).

**s_ali_hassan** · 10-01-2010, 11:58 AM

The thing is, i know that "08:00" exists on the worksheet where i am doing the find. When i do a manual ctrl+F, then it works.

I am copying a worksheet from another workbook into my current worbook and then doing the find on the new worksheet.

It always brings the same error. Do you know how i need to change my code to get around this as i'm not sure why it's not finding the value i'm searching for.

Thanks

**shg** · 10-01-2010, 12:35 PM

Are you looking for a text string or a time?

If the latter,

Please Login or Register  to view this content.

The octothorpe (

) delimits a date constant.

**s_ali_hassan** · 10-04-2010, 05:28 AM

Thanks shg! that's sorted my problem out.

(now just need to set this thread to 'Resolved'!)

Runtime error 91 Objecr Variable of With block variable not set

LinkBack

Thread Tools

Rate This Thread

Display

Runtime error 91 Objecr Variable of With block variable not set

Re: Runtime error 91 Objecr Variable of With block variable not set

Re: Runtime error 91 Objecr Variable of With block variable not set

Re: Runtime error 91 Objecr Variable of With block variable not set

Re: Runtime error 91 Objecr Variable of With block variable not set

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions