ClearContents not clearing :(

  • Thread starter Thread starter JoeH
  • Start date Start date
J

JoeH

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ClearContents not clearing :( 1
Clear a "moving" range offset from Target 31
after clearcontents() new data is positioned below the cleared ran 5
ClearContents terminating macro - using 2 workbooks 2
If range is empty, clear other cells 3
ClearContents or ClearFormats also clears Clipboard. How can I keep the clipboard? 5
clear the values, but not the formulas in a range 3
Code copies between key word is in reverse order 5

Back
Top