Problem With SubTotal In Determining Number of Visible Rows of A Filtered Worksheet (Exclude headers?)

[Ark68]

I have this line of code that I am trying to use to get the count of filtered rows on my worksheet.

f_rowcnt = [subtotal(103,A:A)]

It works, however, the value of f_rowcnt seems to be including the two header rows (rows 1-2) in it's value. This is inaccurate when there are no filtered rows being displayed.

I tried this where lstrow = the value of the last row of data in the worksheet.

f_rowcnt = [subtotal(103,A3:A &lstrow)]

as well as this variation

f_rowcnt = [subtotal(103,"A3:A" &lstrow)]

Each resulting in a type mismatch error.

Looking for some assistance to correct this to ensure the correct value for f_rowcnt is calculated.

 

[mumps]

How about:

f_rowcnt = [subtotal(103,A:A)] - 2

 

[Ark68]

How about:

f_rowcnt = [subtotal(103,A:A)] - 2

LOL ... of course that will work. Embarrassingly simple solution.
Thank you.

 

[mumps]

You are very welcome.