Object variable or with block variable

**RJ1969** · 08-27-2020, 03:49 PM

Hi guys,

I get this message at the end of my search "OBJECT VARIABLE OR WITH BLOCK VARIABLE NOT SET". Some of my search I don't get the message but some of them did get the message.

Please tell me why. Thanks.

Please Login or Register  to view this content.

**vba_php** · 08-27-2020, 03:55 PM

first of all, are you sure this line is right?

Please Login or Register  to view this content.

usually, anything that is associated with a visible property returns a bool type, not a long.

secondly, what line does that error occur on?

more than likely what is happening is that you're running into data in a cell that the code doesn't like. and there are probably an endless amount of possibilities for that scenario. I did not look at your file.

**Fluff13** · 08-27-2020, 04:14 PM

I can see nothing wrong with that code & it should work.
Although if it unhides a sheet & you click Cancel it won't rehide the sheet.

What line does it fail on & what were you doing?

**RJ1969** · 08-27-2020, 06:51 PM

Hi
I attached the file. Please check.

If you click the "search" button and search for Test and at the end you will the message "OBJECT VARIABLE OR WITH BLOCK VARIABLE NOT SET".

I also noticed that if you add another Test to search, then the message disappear. If I have one or two of the Test to search that is when the message appeared.

Thanks.

**Andy Pope** · 08-28-2020, 02:52 AM

@vba_php, worksheet visibility has 3 states so a long is valid. Visible, Hidden and VeryHidden.

**vba_php** · 08-28-2020, 03:00 AM

i was aware of all 3 properties andy. i will look them up to verify that i know what i'm talking about. thank.s

**Andy Pope** · 08-28-2020, 03:10 AM

The FindNext returns nothing so you need to check for that. This does appear to be at odds with the help description which describes FindNext looping around and then returning to first found instance.

Please Login or Register  to view this content.

**RJ1969** · 08-28-2020, 08:13 AM

Hi

What Do I need to do? Sorry, I am not an expert with the VBA.

Do I need to replace any in the code?

Thanks

**vba_php** · 08-28-2020, 09:33 AM

Originally Posted by RJ1969

Hi

What Do I need to do? Sorry, I am not an expert with the VBA.

Do I need to replace any in the code?

Thanks

I think andy has told you what to do. are you not following?

**RJ1969** · 08-28-2020, 11:55 AM

Sorry,
But I saw the code he provided but I don't know where to place the code with the rest.

Please Login or Register  to view this content.

Like, I said I am not good in VBA.

**RJ1969** · 08-28-2020, 11:59 AM

I don't if I am adding the code into the rest of the code which I don't know where place. Or I am deleting some from the original code and replace it.

Thanks.

**Fluff13** · 08-28-2020, 01:00 PM

You just need to add the middle of those 3 lines, into your code between the other two lines

**RJ1969** · 08-28-2020, 02:13 PM

what 3 lines?

is this correct:

Please Login or Register  to view this content.

**Fluff13** · 08-28-2020, 02:19 PM

No just add this line

Please Login or Register  to view this content.

between these two, in your original code

Please Login or Register  to view this content.

**RJ1969** · 08-28-2020, 02:39 PM

it still does the same :o(

see attachment.

**RJ1969** · 08-28-2020, 02:52 PM

Hi All
Never mind. I got it. I added the wrong code... sorry.

Thank you All.

**Fluff13** · 08-28-2020, 03:17 PM

Glad to help & thanks for the feedback.

**protonLeah** · 08-28-2020, 03:24 PM

Please Login or Register  to view this content.

**RJ1969** · 08-28-2020, 04:02 PM

Thank you ProtonLeah

Object variable or with block variable

LinkBack

Thread Tools

Rate This Thread

Display

Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Re: Object variable or with block variable

Thread Information

Users Browsing this Thread

Similar Threads

Updating Checkbox - Run-time Error 91 - Object variable or With block variable not set

[SOLVED] Run-time error '91': Object variable or With block variable not set when closing userform

“Object variable or With block variable not set” error while adding data into ArrayList

Macro issue: Object variable or with block variable not set error

Adding a variable string comment to a cell. "Object Variable or WIth Block Variable Not.."

Run Time Error 91 - Object variable or With block variable not set when using Pie Chart

VBA Loop, Find & Copy run-time error '91': Object variable or With block variable not set

Bookmarks

Bookmarks

Posting Permissions