Thread: Moving a range name AND Contents
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
  
Posts: 468
Default Moving a range name AND Contents
Currently MyRng (a named range) refersto: sheet1 - B2:D4

How can I change that in VBA to sheet2 - D5 (D5:F7)?

I wish to also include the cells B2:D4 values/contents.

How is this done?

Reply With QuoteReply With Quote