View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Woodi2 Woodi2 is offline
external usenet poster
 
Posts: 61
Default find last row and copy previous row data

Could anyone help please. I am looking to create a macro that will find the
last rows data, copy that data then paste it in the row below.
i.e. row 10 is the last row containing data. I want a macro to copy the
data in row 10 and paste it in row 11.
I cant specify the row in the macro as the row numbers will increase each
time the macro is used.
Thanks in advance for any help.