I have a very simple Message Box that appears when a file is opened.
How could I have a variable referred to within this message box e.g if
my text to appear in the message box was referenced to G1 in sheet
"Sales"?

Thanks



Private Sub Workbook_Open()

MsgBox "Maximise Sales for w/c 05/11/07"
Range("A1").Select
Application.DisplayAlerts = True
Application.ScreenUpdating = True

End Sub