Thanks that makes sense.
Any thoughts on why =SUBTOTAL(103,A2) in my worksheet returns a 0 instead of 1 on a visible row?