400 Error When Deleting Rows

Hello,

Scenario background: I have an excel document with several tables and charts. Instead of having users navigate through tabs to see them I am attempting to make a Dashboard sheet that will pull the selected table and chart. I am not having VBA generate the tables and charts, merely copy them from one sheet to the Dashboard sheet. This is working. I recently added an IF statement to see if there is already data on the sheet and if there is, to delete it. When there is no Data on the sheet the macro will run fine, however when there is data on the sheet I receive a 400 Error. I have been Googling solutions and so far all I have seen are solutions based on unprotecting the sheet (none of my sheets are protected) or hidden values (nothing is hidden). Below is my code.

Please Login or Register  to view this content.

JB,

Thank you for the quick response.

The Error handling spit out "Copy method of Range class failed"

JB,

I think I figured it out. It was messing up with the variables in the Copy function. If I change those variables to the Range string that those variables call it works fine.

Thank you very much for the error handling advice. I will definitely be adding that to every worksheet from now on.

Below code works:

Please Login or Register  to view this content.