| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference Names via VBA
We are converting some of our calculating in our spreadsheets to VBA
due to some of excel limitations. We have numerous 2 dimensional defined names. If (for example) I have a defined name of "CUTS" that is 300 x 200 and I wanted to access element (240, 45) how would I do this in VBA using the defined name "CUTS". Also lets say the user picks item 6 off of a validation list how could I use VBA to determine they picked item 6 from the list of 20. Thank You |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting values from names by reference | Excel Discussion (Misc queries) | |||
| reference other worksheets via variable names | Excel Worksheet Functions | |||
| Fixing sheet names is a 3D reference | New Users to Excel | |||
| reference to range names | Excel Discussion (Misc queries) | |||
| Remove reference names | Excel Programming | |||
Threaded Mode
