Extracting 28 from a string

Hello,

I'm using Worksheets("LookupTable").Autofilter.Range.Address and this gives me:

$A$1:$D$28

How can I extract 28 from this string.

(I wan't to know the number of lines rows of my Autofilter.)

Thanks

ephie

Hi,

=Right(cell,2)

HTH
Carim