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!
Bookmarks