Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I higlight and clear contents but not formulas | Excel Discussion (Misc queries) | |||
Clear contents, keep formulas | Excel Discussion (Misc queries) | |||
How do I clear contents from a spreadsheet but not the formulas | Excel Discussion (Misc queries) | |||
How do I clear contents in my workbook w/o loosing my formulas? | Excel Worksheet Functions | |||
Clear contents but leave formulas in Excel | New Users to Excel |