View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nancy C Nancy C is offline
external usenet poster
 
Posts: 3
Default Macro - relative end of data

I want to create a macro that looks for the last ROW of data (which will
always vary) and allows me to copy and paste columns of real data between
spreadsheets. When I RECORD a macro to study the code, it always gives me an
absolute cell reference. How can I modify that macro to point to the
relative end of data? Thanks!