I have spent a reasonable amount of time setting up a spreadsheet with a
particular format. I have changed column widths, row heights and added some
colours to certain cells. I want to copy the format between workseets and
workbooks but when I use the paste function te format deosn't copy.

A friend recommended 'paste special' but this doesn't seem to work either,
even though I choose to retain all the formatting.

Can someone help please.

Geoff Cox