Can you go in to the module that has the macro... find where it says
subtotal...

Then change it to count?

"Cat" wrote:

I'm writing an extensive macro and one of the problems I'm encountering is
adding multiple rows of information that belong to the same record. Say my
record is User Name and Name appears on 5 lines. The lines are capturing data
pulled from a database. If I use the subtotal function then say count change
in user - I get subtotals that would say 5 becasue that's how many lines it's
in. The formula shows =subtotal(3,a1:a5) even though I told it to count. So
I highlight the fcolumn and tell it to mass replace subtotal with count and I
come up with the right answer of 1. I've been staring at this for hours - it
used to work - what am I doing wrong? I don't want to have to do a
workaround. Thanks so much - sometimes the littlest thing... "brain fart"