Hi Sam,

Use the macro recorder with EditGoto, Special, Constants, EditClear,
Contents

That will give you the basis for the code, which of course can be simplified

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"debartsa" wrote in message
...
Hi Everybody,

In Excel 97 I'm using vba and the Object Model to copy a row and insert
its
copy elsewhere. My problem is that with the newly inserted row I'd like to
clear the entire rows values that were copied over, but preserve the
formulas the row contains. I have only found the Range.Clear method which
doesn't preserve the formulas?

Does anybody know what syntax I would use instead?

Thanks for any help!
Sam