autofilter, visible rows count error

Hi florin,

After finding zero hits after an autofilter, your data isn't expanded. The next time you find the LastRowWs it will return 1 instead of 12. I think this is why you get wrong answers.

To fix

After you display the number in your message box, simply unfilter the data and leave it all showing.

Put this after the msgbox

Please Login or Register  to view this content.