run time error '91':

[baig123]

i am getting this error run time error '91':

object variable or with block variable not set



please let me know

Please Login or Register  to view this content.

[MarvinP]

Do you need an End With for each With?

[baig123]

also given the end with

but still showing an error

[zbor]

Do you use this in Worksheet_change or something else?

You attempted to use an object variable that isn't yet referencing a valid object.

You should declare it something like:

Please Login or Register  to view this content.

but you show only part of the code so it's hard to say.

[baig123]

yes i have used this code in the Private Sub Worksheet_Change(ByVal Target As Range)

but it is not letting me to run other macro code in the sheet

see this my whole code

Please Login or Register  to view this content.

[zbor]

it's not declared when you step into other macro

[baig123]

let me know how can i declared because whenever i run the macro code it crashs down

it showing errors

like method_undo

[zbor]

try to use

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

[baig123]

tried this but i am getting an error here

Run time error '1004'
Method 'undo of object_ Application failed

Application.Undo -----------error in this line

[zbor]

This method undoes only the last action taken by the user before running the macro, and it must be the first line in the macro.
It cannot be used to undo Visual Basic commands.

[baig123]

let me other can i

i used to download data from database

i then going to edit

make that undo

that it should allow user to edit if they