vba autofilter

Hi I'm using this Sub to delete rows where the number zero exists in column B. However, if the Sub has already been run and the rows with the number zero in column B have been deleted, then the Sub produces an error. Does anyone know how to exit the Sub IF there are no rows in column B...

Hi I'd like to write some code that will apply a filter to row 1 in a sheet, then filter for a condition in the autofilter then delete everything that turns up when that condition is applied. In the simple example below, I have the title 'Numbers' in cell A1, then the numbers 1, 2, 3, and 4...

Hi I recorded a macro which applies a filter to row 1 of a sheet, then filters data by a specific criteria ie "On Deal." However, when I add a new set of data to that sheet and run the macro, it doesn't work as expected. Can someone please advise how I should amend the code below? The...

I have drafted a macro to automate my excel. 1. Autofilter and create new worksheets based on the filter value with keeping the same format of the original file. 2. AutoFill Destination Range("A5: A6") to the end of the column. 3. Loop the process until the filter fields get over. 4. Filter...

Hello. I can't seem to get this to work. I have 5 fields that need to be auto filtered if they exists in the pivot table. How do I auto filter these if any of them exists in the pivot table? Thank you so much! ' With ActiveSheet.PivotTables("PivotTable2").PivotFields("Check / Trace #")...