Hi,

I am trying to put a concatenate function in a text box. The error
message is as follows:

The text you have entered is not a valid reference or defined name.

I want to concatenate some text with a number from the cell, A2.

Any ideas would greatly appreciated.

Regards

Tubbsy


--
tubbsy
------------------------------------------------------------------------
tubbsy's Profile: http://www.excelforum.com/member.php...o&userid=24743
View this thread: http://www.excelforum.com/showthread...hreadid=388332