JZ,

Yes, you could do that, but it is not needed. Better would be to use subtotals, a pivot table, data
filters, or SUMIF, COUNTIF, or SUMPRODUCT formulas.

HTH,
Bernie
MS Excel MVP


"JZ" wrote in message
...
I have data as follows in A1:B10.

ACCMLS $31,416.00
ACCPRO $35,430.00
ACCSUP $25,834.00
ACCSUP $27,167.47
ACCSUP $18,969.39
ACCSUP $30,281.00
ACCSUP $25,234.00
ACCSUP $26,114.00
ACCSUP $27,296.00
ACCSUP $25,234.00

I need a macro that names each range of numbers with the name in column A
just to the left of the first instance. For example, B1 should be named
ACCMLS. B2 should be named ACCPRO, and B3:B10 should be named ACCSUP.

Can anyone help?