Issues Trying to Delete Rows That are Copied into another sheet

Hi,

I currently have a spreadsheet that is being populated by a dataflow. I have conditional formatting (through excel) set up so entire rows are highlighted red if the value in Column G is negative.

The macro then auto filters this sheet to the cells highlighted in Red and copies those values over to another sheet in the workbook.

After the values are copied, I want to delete them from this original table as the rest of the values are going to be copied into another sheet where I can't include the negative numbers.

Every time I run the macro I get:

Run-time error '1004': Delete method of Range class failed

Please Login or Register  to view this content.

Can you post your workbook ?

Originally Posted by CheeseSandwich

I think you may have issues with an empty table at times, try the below:

Please Login or Register  to view this content.

Also, I tried adding in that code that was just added above and I am still getting the same error with the rang.EntireRow.Delete highlighted.

Ended up solving this by replacing EntireRow.Delete with .Delete

I also had to turn off Alerts to keep from having to click the "Are you sure you want to delete?" popup.

Please Login or Register  to view this content.