Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ClearContents not clearing :(
Hey again Tom ! The value of trm is = 20 20 according to the msgbox and it still doe not clear ?!? Any ideas. Right now it's the last thing in my scrip I'm going to play around with the order and see if that might help thanks as always Joe -- Joe ----------------------------------------------------------------------- JoeH's Profile: http://www.excelforum.com/member.php...fo&userid=1413 View this thread: http://www.excelforum.com/showthread.php?threadid=26368 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ClearContents not clearing :(
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
ClearContents not clearing :( | Excel Programming | |||
ClearContents Not Clearing Query | Excel Programming | |||
Clearcontents | Excel Programming | |||
Clearcontents | Excel Programming |