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:

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.