You could get that expensive patch named Office 2003 <bg.

I screwed up with my earlier response.

JethroUK wrote:

it doesn't work on my works machine (2002 +sp3)

is there any update i can get that includes this feature?

"Debra Dalgleish" wrote in message
...
That feature was introduced in Excel 2003 (but maybe it was in your
special version of Excel 2002 <g).


Dave Peterson wrote:
If you've hidden rows manually in xl2002 or xl2003, you can use the
enhanced
=subtotal() function:

=subtotal(109,a1:a10)



"JethroUK©" wrote:

tried using SUBTOTAL function (XL XP) and it doesn't seem to work

=SUBTOTAL(9,A1:A10) still gives total of rows 1 thru 10 even though i've
hidden rows 5 thru 7

???

is there any other method of working with visible cells only?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


--

Dave Peterson