L
Len
Hi,
In excel vba, how to set dynamic named range so that it can use in
sumif excel formula
E.g.
=SUMIF(Acct, "Total*", xxx)-SUMIF(Acct, "Expenses*",yyy)*-2
Acct refer to named range in column A
xxx refer to dynamic named range in column C
yyy refer to dynamic named range in column D
Can anyone help and thanks in advance
Regards
Len
In excel vba, how to set dynamic named range so that it can use in
sumif excel formula
E.g.
=SUMIF(Acct, "Total*", xxx)-SUMIF(Acct, "Expenses*",yyy)*-2
Acct refer to named range in column A
xxx refer to dynamic named range in column C
yyy refer to dynamic named range in column D
Can anyone help and thanks in advance
Regards
Len