VBA 2 dimensional defined name access

[Network Admin]

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

 

[Bernie Deitrick]

Admin,

myRow = 11
myCol = 3
Msgbox Worksheets("Sheet2").Range("Stuff").Cells(myRow,myCol).Value

HTH,
Bernie
MS Excel MVP