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

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