I have an excel file where i has a VBA for highlight active cell row and column and on this file Redo/Undo function is not working
can you please provide me a solution on this. Thanks
Attached is excel file.
Once you have run macros then undo function will not work on which part for what you have run macros ....for the remaining you can use undo function as usual.....another way is that if you want to undo after run macros then don't save the file after run macros and close the file then open again
Juzar22
While selecting a new row save new selections those cells for further use.
Later if You will use previous selections values then do it with Your own 'UNDO'-button.
If there would need more steps backward to 'UNDO', then You should save more steps for further use.