software

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
quot;Headerquot; which is several columns wide and several rows high.
I need to find a way to copy amp; 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: www.excelforum.com/member.php...oamp;userid=31806
View this thread: www.excelforum.com/showthread...hreadid=515286A standard copy/paste of course handles the values and formatting of the
range. An Edit, Paste Special, Column Widths will handle that aspect.
There is no built-in way to copy row heights, but they will size
automatically to accommodate larger fonts unless the target rows have been
preset to a specific height in advance. If that's not good enough you have
to consider a macro.

--
Jim
quot;davidthegolferquot;
lt;davidthegolfer.23mtmm_1140613801.2595@excelforu m-nospam.comgt; wrote in
message news:davidthegolfer.23mtmm_1140613801.2595@excelfo rum-nospam.com...
|
| 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
| quot;Headerquot; which is several columns wide and several rows high.
| I need to find a way to copy amp; 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:
www.excelforum.com/member.php...oamp;userid=31806
| View this thread: www.excelforum.com/showthread...hreadid=515286
|

Jim,
Thanks for your prompt reply. I guess I needed telling. Macros were the
only way I could solve it. I guess you confirm that. I was hoping
against hope there was another way.
Thank you again.
Kind regards
David--
davidthegolfer
------------------------------------------------------------------------
davidthegolfer's Profile: www.excelforum.com/member.php...oamp;userid=31806
View this thread: www.excelforum.com/showthread...hreadid=515286