Run-time error '91': Oject Variable or with block variable not set

[bharath.achar]

please let me know i am getting error on the line

Please Login or Register  to view this content.

[HaHoBe]

Hi, bharath.achar,

Target (I would prefer to use a different name for the variable) has been dimmed as Range but not been assigned anywhere in the sheet before thus causing the error.

Ciao,
Hoilger

[:) Sixthsense :)]

Just add a single quote (') after then like the below

Please Login or Register  to view this content.

[HaHoBe]

Hi, :) Sixthsense :)

that would get the comment for the line being covered but not the fact that the range has not been set before and still cause RTE 91 for sure.


@baig123:
being banned for some time on a forum doesn´t mean that you should show up with a different username and the very same problems.

Ciao,
Holger

[bharath.achar]

@Sixthsense :

Hello Sir i am Not Baig123
I got this code from excel form, that is using in my project .

[:) Sixthsense :)]

Hi Holger,

Yes, you are right

As you said the OP should set a range in Target or use If with Is not nothing to skip that range if Target is empty