Posted to microsoft.public.excel.programming

BRC[_2_]

external usenet poster

Posts: 19

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Paste to next empty cell in named range of cells	Sully	Excel Discussion (Misc queries)	3	March 4th 10 05:23 PM
Create named range of cells with values in row	CLR	Excel Programming	7	December 20th 09 10:34 PM
Search used cells for values containing named range	mp	Excel Programming	2	September 25th 09 03:41 PM
Macro to select only cells containing values within named range	Code Numpty	Excel Programming	2	November 25th 08 07:36 AM
Clearing Empty Cells.	Michael Koerner	Excel Programming	2	July 1st 07 06:08 PM

All times are GMT +1. The time now is 02:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us