Check If Filtering Worksheet Removes All Rows

[jo15765]

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

[AlphaFrog]

If you're using Autofilter as the filter method, then try something like this...

Please Login or Register  to view this content.

Otherwise, you'll have to elaborate on the nature of your data and the filtering method used. Perhaps if you attached an an example workbook, that would would help explain.

[jo15765]

@AlphaFrog - this gives me an error of object variable or with block variable not set. This is more syntax and how I plan to use it

Please Login or Register  to view this content.

[xlnitwit]

Hi,

For a Table you might make a small change

Please Login or Register  to view this content.

[AlphaFrog]

Or test before you autofilter.

Please Login or Register  to view this content.