Deselect range after autofilter

[mill1174]

This seems incredibly simple and straight forward, but no matter how much testing and searching I do I am unable to resolve. I currently have scripting that turns on AutoFilter without selecting anything, but I thought I could copy the data and paste into a new worksheet without the data being selected. However, after it completes the action it does show columns A:K as selected. I have been unable to figure out how to deselect those columns on the worksheet nor have I been able to find out how to copy and paste without them being selected in the first place. Any guidance is appreciated. Thanks.

ws1.Range("A1:K1000").Copy Destination:=Sheets("copy").Range("A1:K1000")

 

[Jonmo1]

Welcome to the board.

The code as you posted it doesn't select anything.
It must be previous code that did the selecting.

Can you post the whole code?

 

[mill1174]

Full script below


Sub RunScript()


Application.ScreenUpdating = False
Application.DisplayAlerts = False

Dim ws1 As Worksheet
Set ws1 = ThisWorkbook.Sheets("Data")

Sheets.Add.Name = "copy"
Dim galreqws As Worksheet
Set galreqws = ThisWorkbook.Sheets("copy")

Sheets("Data").Select
Range("A:K").AutoFilter

ws1.Range("A1:K1000").Copy Destination:=Sheets("copy").Range("A1:K1000")

galreqws.Delete

'Sheets("Data").Select
Range("A:K").AutoFilter
Range("A:K").Select
Sheets("Buttons").Select


Application.ScreenUpdating = True
Application.DisplayAlerts = True


End Sub

 

[Jonmo1]

This is the line that's doing it.
Range("A:K").Select

It can just be removed, it's not needed at all.