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"

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"

Well - I said I was silly - that would work and here I went and wrote this
big ol replace deal. I still don't know why I can't get the right count on
non-number fields. I know I was able to do it in the past - but was upgraded
recently. The smallest things are getting to me - I've discovered way too
often that when they do a mass upgrade, somebody forgot to "buy" the whole
package. I'm diverting - thanks for getting back to me.

"AKphidelt" wrote:

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"