I have a worksheet that is being filtered based of selected criteria and certain columns are being copied to a new worksheet and a few calculations being performed. The issue I am running into is that when the filter criteria yields 0 results I get a division by 0 error.
How can I get a count of the rows being displayed after filter condition applied, and conditionally carry on based off the filtered number of rows?
EDIT -> And if it makes a difference this is for an access query that was imported from access in Excel
Bookmarks