There is not skip cells with formulas option in pastespecial.

--
Regards,
Tom Ogilvy

"aehan" wrote in message
...
I want to copy data from a workbook to overwrite data on another workbook
but
not to overwrite the formulas. The original worksheet will have either
empty
cells or the value of 0 in the cells that contain the formula in the
workbook
it is being pasted to. I can't find an option in Paste Special. Can
anyone
help with this? Many thanks.