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