Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How does one refer to a named area in a worksheet from within a VB macro
subroutine? I know how to refer to a selection, but not a block of cells that has been named using the Insert|Name|Define dialog. Example: I have a 3x3 block of cells named AA. How can I refer to the individual cells within AA [e.g. AA(1,2)] within the VB coding of a macro (subroutine)? How can I make the name AA visible within the subroutine, and define it a s 3x3 array? Thanks. -- Jay. (remove dashes for legal email address) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
name of another worksheet in cell for reference | Excel Worksheet Functions |