Runtime Error '91' when assigning range to variable

**tpampalone** · 03-24-2021, 02:30 PM

Hello everyone,

I am new to the vba/excel syntax and am currently working to debug an issue with a macro.

Here's the segment of code from the subroutine
----------------------------------------------------------------------------------------------------------------

Please Login or Register  to view this content.

------------------------------------------------------------------------------------------------------

My guess is it thinks:

Set comRange = comSheet.Range("A1:A" & comEndRange.Row)

has not been referenced or defined yet, however it has been initiated at the top of the sub.

Any and all help appreciated.

Thanks in advance.

**jolivanes** · 03-24-2021, 02:45 PM

Take a little of your precious time and read the Forum Rules. #2 Is interesting for you.

Re: "the variable"
Which one would that be?

**tpampalone** · 03-24-2021, 02:55 PM

My apologies, hopefully the updating formatting is correct.

**Fluff13** · 03-24-2021, 03:21 PM

If ITEMID1 is not found in comRange then comEndRange will be nothing, which will return an error with

Please Login or Register  to view this content.

as you cannot get the row number from nothing

**tpampalone** · 03-24-2021, 04:20 PM

Thank you. I will investigate this issue and post updates.

Runtime Error '91' when assigning range to variable

LinkBack

Thread Tools

Rate This Thread

Display

Runtime Error '91' when assigning range to variable

Re: Runtime Error '91' when assigning range to variable

Re: Runtime Error '91' when assigning range to variable

Re: Runtime Error '91' when assigning range to variable

Re: Runtime Error '91' when assigning range to variable

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Public variable and Runtime error 91: Object Variable or With block variable not set

[SOLVED] Runtime Error 91: Object variable or With block variable not set

Runtime error 91 on range variable

I m getting the error: Runtime error 91: “ Object variable or With block variable not set”

[SOLVED] Assigning A Cell Address to A Variable, Using A Variable - Error '1003'

[SOLVED] Runtime Error '91': Object variable... When Running in Range Selection

Runtime error 91 when assigning range

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions