Hello,

I'm trying to run this section of my code:

Workbooks("Master Spreadsheet vs Database Macro.xls"). _
Sheets("Results").range(Cells(7, 1), Cells(50, 9)).Sort _
Key1:=Workbooks("Master Spreadsheet vs Database Macro.xls"). _
Sheets("Results").Columns("E"), Order1:=xlAscending

and I get this error:

Run-time error '1004';
Application-defined or object-defined error

I know the problem has something to do with using the range

(Cells(7, 1), Cells(50, 9))

, because it works if I use the range

("a7:i50")

instead. Shouldn't both ranges work?

Thanks in advance,

Jeff