View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
davidthegolfer
 
Posts: n/a
Default Copy the formatting and content of a range


I wish to create a complex (pricelist) template which contains many
named ranges. When creating new individual price lists which contain
common ranges from the template, I need to select say range called
"Header" which is several columns wide and several rows high.
I need to find a way to copy & paste the formatting and content of a
range, preserving different row heights and column widths, together
with titles etc.
So far I haven't found a solution. Any help gratefully appreciated.
Thanks in advance.
Kind regards
David


--
davidthegolfer
------------------------------------------------------------------------
davidthegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31806
View this thread: http://www.excelforum.com/showthread...hreadid=515286