In my activesheet I have the value Memphis

In my code I'm try to get the Msgbox to say:

Memphis has not reported in today<<
but the following is turning red in my code window;
can someone assist?

MsgBox "Range("D1").value & " has not reported in today"

hi,
one double quote too many. try this
MsgBox Range("D1").value & " has not reported in today"

another way.....
Dim r As Range
Set r = Range("D1")
MsgBox r.Value & " has not reported in today"

regards
FSt1
"JMay" wrote:

In my activesheet I have the value Memphis

In my code I'm try to get the Msgbox to say:

Memphis has not reported in today<<
but the following is turning red in my code window;
can someone assist?

MsgBox "Range("D1").value & " has not reported in today"

MsgBox activesheet.Range("D1").value & " has not reported in today"

I'd qualify the range with the sheet and/or the workbook/sheet.

And just in case:

MsgBox activesheet.Range("D1").value _
& " has not reported in today: " _
& format(date,"mmmm dd, yyyy")

JMay wrote:

In my activesheet I have the value Memphis

In my code I'm try to get the Msgbox to say:

Memphis has not reported in today<<
but the following is turning red in my code window;
can someone assist?

MsgBox "Range("D1").value & " has not reported in today"

--

Dave Peterson

Thanks Guys

"Dave Peterson" wrote:

MsgBox activesheet.Range("D1").value & " has not reported in today"

I'd qualify the range with the sheet and/or the workbook/sheet.

And just in case:

MsgBox activesheet.Range("D1").value _
& " has not reported in today: " _
& format(date,"mmmm dd, yyyy")

JMay wrote:

In my activesheet I have the value Memphis

In my code I'm try to get the Msgbox to say:

Memphis has not reported in today<<
but the following is turning red in my code window;
can someone assist?

MsgBox "Range("D1").value & " has not reported in today"

--

Dave Peterson