I keep getting the error 91 but i cant figure out what is wrong here.

[rmason]

Sub Refsh_Pvt()
'
' Refsh_Pvt Macro
'

'Grab Pivot Table Info

Sheets("Reject Data").Select
Range("U9:W133").Select
Selection.Copy

'Paste into N8

Range("N8").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

'Filter Data

Range("N8:P65").Select
Application.CutCopyMode = False
Selection.AutoFilter
ActiveWorkbook.Worksheets("Reject Data").AutoFilter.Sort.SortFields.Add2 Key _
:=Range("N8:P165"), SortOn:=xlSortOnValues, Order:=xlAscending, _
DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Reject Data").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With

'Select N4
Range("N4").Select
End Sub

 

[rmason]

Sub Refsh_Pvt()
'
' Refsh_Pvt Macro
'

'Grab Pivot Table Info

Sheets("Reject Data").Select
Range("U9:W59").Select
Selection.Copy

'Paste into N9

Range("N9").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

'Filter Data

Range("N9:P59").Select
Application.CutCopyMode = False
Selection.AutoFilter
ActiveWorkbook.Worksheets("Reject Data").AutoFilter.Sort.SortFields.Add2 Key _
:=Range("N9:P59"), SortOn:=xlSortOnValues, Order:=xlAscending, _
DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Reject Data").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With

'Select N4
Range("N4").Select
End Sub



I fixed the cells, but error is still there

 

[mumps]

Which column do you want to use as the sort criteria? Does the data you want to sort contain headers? It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).