Adjust macro to NOT delete source row when change is detected.

[mefaraway]

The following macro checks for a change in column J on "HVAC Master Roster". If so, the source row is copied and pasted onto another sheet called "Placed". It then deletes the source row on "HVAC Master Roster". I want to change it so everything remains the same, except the source row will not be deleted when a change is detected. Would appreciate any help you can provide. Thank you.

Please Login or Register  to view this content.

[Trebor76]

Hi mefaraway,

Just comment out this line...

Please Login or Register  to view this content.

...by putting a single apostrophe at its start so it looks like this:

Please Login or Register  to view this content.

Comments are ignored during VBA execution.

Regards,

Robert