Yep, that is what I needed, I knew I had to be missing something
obvious. Thanks a bunch.
Tom Ogilvy wrote:
Your missing the subtotal worksheet function which will do what you want
without events or code.
=subtotal(9,A1:A200)
the first argument defines the math operation to perform. 9 is sum, 3 is
count as examples. See Help in excel for details.
--
Regards,
Tom Ogilvy
"Merlin" wrote:
Okay fo starters I may very well be making this harder then it needs to
be.
My overall goal is to sum up 4 columns and have that sum change and
reflect the use of filters.
Unfortunately I had no luck finding a way to have the Sum function
ignore rows that were filtered out.
So I wrote a little VB script that does this for me.
What I would really like to do now is link that VB script to a 'filter
event', so when you change the filter, the totals automatically update.
There doesn't seem to be a filter event.
I am sure once again I am missing something obvious.
Thanks in advance for what I am sure will be a number of useful replies.