You can also use a function

=SUBTOTAL(3,A3:A500)&" of "&COUNTA(A3:A500)&" Records Found"



--

Regards,

Peo Sjoblom

"Jonathan Horvath" wrote in
message ...
going to answer my own question...

for a workaround check out:
http://support.microsoft.com/default...;EN-US;q213886

I found it after posting the question.

Jonathan