in your posting, you didn't show a period in front of column, but that could
have been removed by the mail program. If you don't have a period, you
should have:

.Columns("C:L").Rows("70:89").ClearContents

Otherwise, it could be clearing on the wrong sheet.
--
Regards,
Tom Ogilvy

"JoeH" wrote in message
...

Hey again Tom !

The value of trm is = 20 20 according to the msgbox and it still does
not clear ?!? Any ideas. Right now it's the last thing in my script
I'm going to play around with the order and see if that might help

thanks as always
JoeH


--
JoeH
------------------------------------------------------------------------
JoeH's Profile:
http://www.excelforum.com/member.php...o&userid=14138
View this thread: http://www.excelforum.com/showthread...hreadid=263686