|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 3rd, 2004, 04:26 AM
|
|||
|
|||
Use defined names in VBA?
Hi all
Any way to have Excel generate links or dimension variables so that VBA can use the defined names on the spreadsheet (menu: insert name define)? Or is it best to just Dim all the same variable names in code to match the defined names? Thanks! 
|
|
#2
August 3rd, 2004, 06:31 AM
|
|||
|
|||
|
Use defined names in VBA?
Hi
try something like dim rng as range set rng=range("your_defined_name") msgbox rng.address -- Regards Frank Kabel Frankfurt, Germany JRocket02 wrote: Hi all Any way to have Excel generate links or dimension variables so that VBA can use the defined names on the spreadsheet (menu: insert name define)? Or is it best to just Dim all the same variable names in code to match the defined names? Thanks!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Defined names and SUMPRODUCT | Steve | Worksheet Functions | 6 | July 21st, 2004 07:42 PM |
| Defined Names in an If Statement | SharonSmith | Worksheet Functions | 3 | March 25th, 2004 04:04 PM |
Linear Mode
