| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to define ranges
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What does it mean define ranges in Excell for import | New Users to Excel | |||
| Using Cells Method to define Ranges | Excel Programming | |||
| Automatically define series of named ranges | Excel Programming | |||
| Define name in macro | Excel Programming | |||
| Macro to Define Range Name | Excel Programming | |||
Threaded Mode
