Dear Friends,
I have a VBA that copies the formula in Range "A6:C6" to range "A6:C5000". This code is activated when the user press a button displayed on the sheet.
But what I want is that when user insert or delete row/rows, they should get a message window " You have inserted or deleted row/rows, please click 'OK' to update the formula in Sheet" (Option to click 'OK') and then the code should be executed. Given below is the code.
Kindly let me know how to have a message window displayed when user insert/delete row/rows and clicking ok will execute the code.
Thanks,
Rahul
Bookmarks