Hi
try doing this manually while recording a macro. Also use 'Edit - Paste
Special - Values' to paste your content

--
Regards
Frank Kabel
Frankfurt, Germany


sminky wrote:
Hi

I am using Excel 97 (VBA)and have a problem. Basically what I want
to
do is copy two cells, clear the whole sheet and then paste the
contents of the cells back onto the sheet. The problem I am having
is
that as the contents of the cells are derived from a calculation on
the sheet, when it attempts to paste the contents back onto the sheet
there is nothing to paste (don't know why). I am attempting to do
this using a macro.

If you understand my problem and think you can help, please post the
relevant code.

Thanks