View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon M[_3_] Jon M[_3_] is offline
external usenet poster
 
Posts: 1
Default How do I write a macro to delete all rows from the first empty ro.

Does anyone know how I could write a macro to delete all rows from the first
empty row to row 2000 please? If I use the control+shift+down arrow and then
go down one cell, the macro programmes the precise cell reference -- but this
changes on datasheets with different amounts of data. HELP PLEASE!!!