I have a msgbox alert that say's something like:

msgbox "Cell A1 displays XXXX "

I want the XXXX to be whatever the value is in cell A1.

Is this possible??

Regards

Corey

Corey,
Dim MyRange as range

set MyRange=Range("A1")

msgbox "Cell " & MyRange.address(false,false) & " displays " & MyRange.Text

You now know the difference between .Value and .Text, but as the msgbox text
says "displays", I assume .Text.

NickHK

"Corey" wrote in message
...
I have a msgbox alert that say's something like:

msgbox "Cell A1 displays XXXX "

I want the XXXX to be whatever the value is in cell A1.

Is this possible??

Regards

Corey

thanks again

--
Regards

Corey