MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to refrence another cell from within a text string


Posted by Marshall on February 04, 2002 11:45 AM

Ok, I need to use a text string in one cell, say cell B2 in another cell, say B3.

Say B2 contains the letters ball .

B3 contains the following:
=QLink|Bars!'textstring,1,1000,C'

I want textstring to be ball , but right now I have to hand change the textstring every time. How can I make it reference B2 instead?

Also, how do I make a VB macro to type ctrl + shift + enter after changing the string in cell B3?

Your help is greatly appreciated.


Posted by anno on February 04, 2002 2:09 PM

would =Qlink|Bars!B2&" ,1,1000,C" do it? don't know about vba for cse.