Error 1004 Method range of object when trying to clear range selection

[shoulddt]

Hello,
I am having rookie problems when trying to make code to clear a range from cell A3 to the bottom right corner of the table. I get the following error:
Run-time error'1004':
Method'Range'of object'_Worksheet' failed

I am sure it is a simple issue on my part, but I cannot figure it out. I have searched the forums to find a similar issues, but nothing I've found fixes the issue.

Please Login or Register  to view this content.

Thanks in advance for any help.

[AlphaFrog]

Qualify the worksheet for both the Range A3 and the end range. Also, you cannot .Select a range unless its sheet is selected.

This will qualify both the start and end range with the worksheet and clear the cells without selecting the range or sheet.

Please Login or Register  to view this content.

[jolivanes]

Change sheet reference as required

Please Login or Register  to view this content.