Thread: How do I make a macro seek the botom of a list?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chads_vstream[_2_] chads_vstream[_2_] is offline
external usenet poster
  
Posts: 2
Default How do I make a macro seek the botom of a list?
I'm trying to copy data from a file and paste it at the bottom of other data
using a macro. manually, i would copy the selection toggle to my other open
sheet, press CTRL <down to jump to the bottom of the data and then paste.
when i try this in a macro it always jumps to a specific cell rather than a
relitive one. anyone know how to rewrite the VB code to make this relitive?
Reply With QuoteReply With Quote