I have tried and tried to get the VBA code working that will tell me the number of visible rows in an autofiltered set of data, but the result I seem to be getting is always "1". Below is the most simple form of the code that I am using (it is based on previous posts and tutorials on this site). Can someone determine from this what I am doing wrong? (I have also attached a workbook with sample data and the code)
Thanks in advance for any assistance!