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: