Vba Cell Address Question

  • Thread starter Thread starter MJSlattery
  • Start date Start date
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Title change with Drop Down Selection 2
Furmula Dependent Cell References 2
Drop Down lists? 1
Question about a range of cells 2
referencing drop down menu values in IF-then statements? 4
PDF files in MS Frontpage 2
Drop Down Question 3
Creating drop downs in a cell contingent on another drop down 1

Back
Top