From this message he

(http://groups.google.ca/groups?hl=en&lr=&ie=UTF-
8&threadm=i4esc01gdj2n0kqqevo1rfdfpdahvc21e9%
404ax.com&rnum=9&prev=/groups%3Fq%3Dstargatefan%26hl%3Den%
26lr%3D%26ie%3DUTF-8%26group%
3Dmicrosoft.public.excel.programming%26scoring%3Dd %26selm%
3Di4esc01gdj2n0kqqevo1rfdfpdahvc21e9%25404ax.com%2 6rnum%
3D9)

I was giving this coding to get automatic line numbering
that would work whether filtered or unfiltered data was
being looked at:

in A2, =SUBTOTAL(2,$B$2:B2)

This has worked fine in all the E2K worksheets I've used
it on but isn't working in Excel 2002.

Any ideas on why that might be? I get a 0 in every single
cell I use the above on.

Thanks!