Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use Names in VBA
In Excel you can Name columns and rows and use the names to reference a cell. eg. = rowName columnName, gives the value of the cell where the row and colum intersect. Is there anyway I can do this with Arrays. I can do this by substituting the column number to represent column Name. Everytime the program sees a Name it has torkout the colum number which is inefficient for the application. Since the Names are variables. the question is how can the program assign a number value to a variable Name when its first encountered, so that when the user uses that Name again the program uses the associated number value Thank for any suggestions Kurb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
return all worksheet tab names and chart sheet tab names in report - an example | Excel Programming | |||
Change names of files in a folder to match names in Excel Column | Excel Programming |