Msgbox syntax error
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
|