I would like to export the existing data in a worksheet to another one
retaining only formats, values and page layouts. The solution I found
for formats and values is to use the past special function twice, one
for formats, one for values. How do I export the page set ups? Is
there a command I am not familiar with, a macro perhaps?

Thanks

PiPPo