So if I had formulas in those cells I'd want to use the:

Range("L" & Rchange, "T" & Rchange).Value = vbNullString

code instead, right? Which is probably smarter UNLESS I actually wanted to
clear out the formulas (which doesn't seem to likely).

Thanks for all the help!

"stevebriz" wrote:


clear.contents is fine...Clears the formulas from the range. Clears the
data from a chart but leaves the formatting.

A good starting point is Excel VBA programming for dummies...this how I
started off..then tried a few different things and search the net if I
got stuck..and use the forums when really stuck!