Thread: Deleting a row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MarkN MarkN is offline
external usenet poster
 
Posts: 104
Default 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