Subscript Out of Range When clearing contents
Posted on 2014-02-28
I have noticed when I occasionally run the below code from the VBA panel I get Subscript Out of Range. This only seems to happen if I were last in the worksheet called "REPORT-JAN". If I then manually go to another worksheet and re-run the SUB then I do not have this issue..Any ideas why I get this message...Why should it matter what worksheet I am in when clearing a worksheet ?
Also if I want to clear everything in A-R, then what is the syntax for this...I fear that one day my data may go beyond row 5,000..Should I just find the LastRow or is there an easier way...
With Sheets ("REPORT-JAN")