Need to add the cut function in the macro

Hello ,

I need to cut the rows after I copied them in the new sheet (If Not foundTrue Then...)

Does someone know how to add this function in the macro below and how to add a pop up window if everything is found :True ?

Thanks in advance!


______________________________________________________________

Please Login or Register  to view this content.

Hi. Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi,

By cut do you really mean that you want to delete the rows or merely the contents of the cells?
In which case then untested without the workbook

If so then either

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Immediately after the Copy instruction would probably be the optimum place - certainly not before

Glad to have helped and thanks for the rep.