run time error 1004

[Mr Marvin]

hi, i need some help please. i have a workbook with several worksheets in that contained macro. i am trying to create a macro that would call on other macros to save doing it individually. when i start the process it gets so far then i come up with a run time error 1004 on this code

Sub SortDataWithHeaderCondAcc()

Worksheets("CondAccData").Range("A1:N1000").Columns.Sort key1:=Columns("F"), Order1:=xlDescending


End Sub

i am at a loss. i have a worksheet in the same workbook called data with the same code and it works fine..

 

[Mr Marvin]

this is my call macro code

Sub Macro1()

Application.Run "FormatPivotTable"




'The following line will run Macro2
Call CondAccDataMacro2

'When Macro2 is complete the code will continue
'to run below the call line in this macro

Call Macro3

End Sub