I want to make the Autosum button use subtotal(9, ..) rather than sum.
I see in this group many messages telling how to use Autosum
functionality via VBA to select the autosum range, and then substitute
a new formula in the activecell.

just curious if there is another way for this specific requirement. I
thought this might be a common requirement but my searches didn't show
it as such.

(Excel 2000)

regards,
Tim