Table Object after filtering - Count visible rows & First visible row

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!

Have a look on SUBTOTAL and better send a file sample with a display of the results you want

Thanks so much! It works very well!

Hi again,

I am sorry for coming back to this, but that code works fine when I have more than one visible row in the table body. With no visible cells on the table body, it give the same count as with one visible row, 1.

I am using the code specially to find if is there any entry or not and use it in case it exists. Can you please have a look on the code?
Thank you!

Also the statement does not work then there are no visible rows in the table body.

Please Login or Register  to view this content.

Thank you for your answer. Actually I was trying different combinations and I just pasted one different from your suggestion. Here is a sample - Can you please have a look on it? Thank you in advance!

Thank you Norie! So far so good... I know that this can be too much, but would you be able to explain why your previous solution did not work? It looked less complex than this alternative.

Anyway, thank you so much!