Clear contents of row but preserve formulas?
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 |
Clear contents of row but preserve formulas?
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 |
Clear contents of row but preserve formulas?
Thanks for the reply Niek!
Unfortunately Excel 97 doesn't structure it's Edit menu that way... I'll try to find if that feature even exists in '97 Thanks Sam "Niek Otten" wrote in message ... 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 |
Clear contents of row but preserve formulas?
activeCell.EntireRow.Specialcells(xlConstants).Cle ar
-- Regards, Tom Ogilvy "debartsa" wrote in message ... Thanks for the reply Niek! Unfortunately Excel 97 doesn't structure it's Edit menu that way... I'll try to find if that feature even exists in '97 Thanks Sam "Niek Otten" wrote in message ... 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 |
All times are GMT +1. The time now is 11:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com