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