Thread: How do I copy data range of the same name to another tab?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How do I copy data range of the same name to another tab?
worksheets(1).range("somenamehere").copy _
destination:=worksheets(2).range("somenamehere").c ells(1)

Maybe????

Amy Wong wrote:

I can copy the data range of the same name by copying the whole worksheet.
But if I have already created a worksheet. I have no way to copy the data
range of the same name. Please assist.

--

Dave Peterson
Reply With QuoteReply With Quote