View Single Post
  #1   Report Post  
Anthony
 
Posts: n/a
Default Add a Message Box

Hi,
I have the code below (attached to a button) which adds a list of items to
a seperate log, can somebody tell me what code to add to it that will produce
a message box confirming the data has been placed in the new worksheet.
Thanks
Excel novice !!

Sub add_monday_jobs()
With Sheets("monday'S LOG").Range("A8:N34")
Sheets("Log").Range("A" & Rows.Count).End(xlUp).Offset( _
1, 0).Resize(.Rows.Count, .Columns.Count).Value = .Value

End With
End Sub