Vba Cell Address Question

M

MJSlattery

No, I have a drop down menue that quaries the internet for stock dat
based upon the stock selected in that drow down menue. Since the dro
down menue has a control cell linked to it I would like to utilize tha
number which is in D5 on the sheet as a of determining where to pu
data, i.e., the closing price of the stock selected.

What I am looking for is a way to reference a cell address with th
value of another cell.

Any ideas?

Thanks,

Michae
 
B

Bob Phillips

Michael,

Do you mean something like

Range("D5").Offset(0,5)

which directs you to I5. The 0 (num rows offset) and the 5 (num columns
offset) can be variables.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top