Deleting a row
Hello,
I have a macro that finds a specific value in column one, cuts the entire
row and then pastes it to a specified location within the same sheet.
My only problem is that I need to delete the row from where I have cut the
record. The macro is essentially a report formatter and so there are
deliberate blank lines through the report. How can I cut a row of
information, paste it and then go back to the same row to delete it?
--
Thanks in advance,
MarkN
|