Macro not working when sharing workbook

G

GATORWOMAN48

New member
Joined
Jan 21, 2020
Messages
4
Reaction score
0
Points
0
Excel Version(s)
Excel 2016
I offered to send my teammates my excel workbook so that they could use it for their purposes. After I sent it to one colleague I showed her how the macro works. For some reason when she hits the "Complete" button for the macro it is taking the header row (Row 2 in my workbook) and moving it along with the row(s) that have "Yes" in Column 'F'. Is there something else I should code for or is there something else? Here is the code I currently have. It works as expected for me but not when I saveas and save it with their name it the name of the file. Could that be it as well?

Code: 
Sub COMPLETEDTICKETS()
 Application.ScreenUpdating = False
 Application.DisplayAlerts = False
         Range("F2", Range("F" & Rows.Count).End(xlUp)).AutoFilter 2, "YES"
         Range("A3", Range("J" & Rows.Count).End(xlUp)).Copy Sheet2.Range("A" & Rows.Count).End(xlUp)(2)
         Range("A3", Range("J" & Rows.Count).End(xlUp)).Delete
         [F2].AutoFilter

 Application.CutCopyMode = False
 Application.DisplayAlerts = True
 Application.ScreenUpdating = True
 Sheet2.Select
 End Sub
 
Last edited by a moderator:
The macro will be the same in both workbooks and won't change, same can't be said for the sheets.
While your headers are in row 2, I suspect her headers are in row 3 because the top of the range to copy and delete is hard coded to start at A3.
 
Bump
(Duplicate thread posted by OP, now deleted.)
 
Last edited:
You must log in or register to reply here.
Back
Top