copy & paste

[Roger]

How would I copy & paste to a new sheet the format & formula but not the data

[George]

Roger wrote:
> How would I copy & paste to a new sheet the format & formula but not the data
>
Its probably easier to copy it all then use EDIT/GOTO (Ctrl-G)
The click on SPECIAL and select CONSTANTS then OK

and finally press DELETE

George