Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clearing values of cells in named range(s) so the cells are empty
Hi all
I am working on project where i paste data-set into a worksheet (sheet1) , do several calculations and put the results specific cells on sheet2. I am using named ranges for the cells in sheet2 that receive the data. WHat i am trying to figure out is a way to set the cells in the named ranges on sheet2 to 0 or "" before starting the routine that does all the calculaions. This way I can be sure that the data on sheet2 belongs to current set of calculations. Thank you in advance for any advise. BRC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
clearing values of cells in named range(s) so the cells are empty
Assuming one of the named ranges is name SomeRangeName, then this statement
will clear the values in its cells... Range("SomeRangeName").ClearContents Note: The surrounding quote marks are necessary (the argument to the Range statement is a String value)... just replace my example SomeRangeName with your actual range's name (or a String variable equal to its name or a String expression that evaluates to the name). -- Rick (MVP - Excel) "BRC" wrote in message ... Hi all I am working on project where i paste data-set into a worksheet (sheet1) , do several calculations and put the results specific cells on sheet2. I am using named ranges for the cells in sheet2 that receive the data. WHat i am trying to figure out is a way to set the cells in the named ranges on sheet2 to 0 or "" before starting the routine that does all the calculaions. This way I can be sure that the data on sheet2 belongs to current set of calculations. Thank you in advance for any advise. BRC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste to next empty cell in named range of cells | Excel Discussion (Misc queries) | |||
Create named range of cells with values in row | Excel Programming | |||
Search used cells for values containing named range | Excel Programming | |||
Macro to select only cells containing values within named range | Excel Programming | |||
Clearing Empty Cells. | Excel Programming |