Just to add to anilsolipuram's post.

If you've never writtin a macro before, you may want to look at David
McRitchie's site:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

=========
Another non-macro approach.

Give that range of cells that should be cleared a nice name.

Select the first cell and ctrl-click on subsequent cells.

Then Insert|Name|Define

Then when you want to clear those cells, you can hit Edit|Goto, type in that
name you created (hit enter) and then hit the delete key on the keyboard.

JoeBed wrote:

Damon,
Thanks for responding to my question. I don't understand what you are
saying. What is (Dim my cell as Object)? Is that part of the formula?
What would the formula look like?
JoeBed

--
JoeBed
------------------------------------------------------------------------
JoeBed's Profile: http://www.excelforum.com/member.php...o&userid=21368
View this thread: http://www.excelforum.com/showthread...hreadid=380317

--

Dave Peterson