Cut & Paste Macro

[luke_p]

I have the following code to cut (where value in cell = "closed") & paste to another sheet but can someone help me so it:

cuts and then pastes special values to sheet2 and
then a msg pops up saying whether it was successful or not?

Please Login or Register  to view this content.

[stanleydgromjr]

luke_p,

This works in my test environment with Sheet1 (your data), and Sheet2.

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Press and hold down the 'ALT' key, and press the 'F11' key.

Insert a Module in your VBAProject, Microsoft Excel Objects

Copy the below code, and paste it into the Module1.

Please Login or Register  to view this content.

Then tun the "PasteRowDelete" macro.


Have a great day,
Stan