Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA 2 dimensional defined name access
I have multiple sheets in our project. Sheet1 contains the interface
and Sheet2 contains a Defined range ("Stuff") that is 10 columns wide x 25 rows deep. In sheet1's VBA code Im trying to get the specific element out of "Stuff" based on user input into sheet1. Example if a user chooses 3 for the first choice and 11 for the second choice I want element in column 3 row 11 to be returned. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA 2 dimensional defined name access
Admin,
myRow = 11 myCol = 3 Msgbox Worksheets("Sheet2").Range("Stuff").Cells(myRow,my Col).Value HTH, Bernie MS Excel MVP "Network Admin" wrote in message om... I have multiple sheets in our project. Sheet1 contains the interface and Sheet2 contains a Defined range ("Stuff") that is 10 columns wide x 25 rows deep. In sheet1's VBA code Im trying to get the specific element out of "Stuff" based on user input into sheet1. Example if a user chooses 3 for the first choice and 11 for the second choice I want element in column 3 row 11 to be returned. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
Transposing from two dimensional to one dimensional | Excel Worksheet Functions | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) | |||
Word.Document - user defined type not defined | Excel Programming | |||
Application-defined or object-defined error | Excel Programming |