I have the below code which works great. After searching this and other forums I can't find a suitable code that will allow me to store the number of rows copied to display in a message box. Thank you for your help!
Dim tgtWB As Workbook
Dim tgtPath As String
Dim ws As Worksheet
Dim lr As...