Hi friends,
If I delete the value in column ‘B’ then I get a warning message ‘do you want to delete the value? Yes/no.
If I click on yes then no problem but if I click on ‘no’ then I’m getting run-time error 1004 method ‘undo’ of object application failed.
Any help will be highly appreciated.
Please Login or Register to view this content.
Thanking you,
Sincerely,
mso3
From reading, there does not seem to be anything wrong with the code - and it runs just fine.
You are making changes to a range of cells within a Change Event handler. You need to switch off Event handling before making changes and on again afterwards.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi Cytop,
Thank you. Then why the error is?
Hi TMS,
Thank you. I added
but same error. Where to insert it to avoid error?Please Login or Register to view this content.
Please send me the amended code.
Better you upload a sample copy of your workbook that displays the issue.Please send me the amended code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks