View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RD Wirr RD Wirr is offline
external usenet poster
 
Posts: 55
Default Dynamic range with VBA

I need to copy a variable sized range of data from one sheet and paste it
onto the end of a list on another sheet from a VBA routine. I have tried
accessing the variable source range via a dynamic named range setup in the
worksheet itself but my limited skill grinds to a halt when I try to grab
that data and append it to the new list. Can someone help me with a bit of
code for this?
Thanks in advance,
RDW