Hi,

I have been working with tables and sometimes I do not get the right value for rows counts and first visible row (excluding headings).

I have a table object - TabResults filtered usind field 2 with criteria "Active".

Could you please share a very reliable way to:

Process 1 - Count visible cells (without heading) that gives 0 when no results are found after filtering.

Process 2 - Get the row number of the first visible row (excluding headings), and showing a msgbox "No visible row" when no visible are available.

This is pretty much the basis of my code to use a database. So it must be very solid.


Thank you very much for your help!