Do you mean

MsgBox "The answer is in A1"

or

MsgBox "The answer is " & Range("A1").Value

--

HTH

RP
(remove nothere from the email address if mailing direct)


"saziz" wrote in message
...

Hi All,
I have written a macro to do several calculations in several sheets.
Now I want to put the answer in a message box. The answer is in a
defined field. All I am trying to do is "the answer is" & "here I want
to give address of the defined filed"
How can I do that?
Thanks for ur help.
Syed


--
saziz
------------------------------------------------------------------------
saziz's Profile:
http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=382585