I am trying to sort some data taken from a worksheet & after a temp worksheet is made sort that data A-Z
I have at present this code but getting confused why it fails to sort.
can you advise please where Ive gone wrong.
The data is copied from the source sheet, the temp worksheet is created & the values then pasted. Now this is where it fails when it attempts to sort.
- Private Sub NEWSHEET_Click()
- Sheets.Add(After:=Sheets("INFO")).Name = "SORT SHEET"
- Worksheets("HONDA SHEET").Range("C21", Range("C" & Rows.Count).End(xlUp)).Copy Worksheets("SORT SHEET").Range("A1")
- Worksheets("SORT SHEET").Activate
- Worksheets("SORT SHEET").Range("A1", Range("A" & Rows.Count).End(xlUp)).Sort [A1], xlAscending
- End Sub