Just replace your entire .Clear statement with mine. And check out Resize
in Help.

--
Jim
"tbassngal" wrote in message
oups.com...
| So would it be like:
|
| Cells(i,
| 19).resize(20).resize(21).resize(22).resize(23).re size(24).Clear
|
| ???
|
| This doesn't make sense to me... I've never used this before.
|