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.