Application-defined or object defined error

[Guest]

Hi, I get the above message on the following line, Im clearly doing
something wrong:

Range("A & (cells(1,1).End(xlDown).Row + 1):aj50").Select

 

[Tom Ogilvy]

Range("A" & cells(1,1).End(xlDown).Row + 1 & ":aj50").Select

 

[JE McGimpsey]

Try:

Range("A" & Cells(1, 1).End(xlDown).Row + 1 & ":AJ50").Select

or, alternatively

Range(Cells(1, 1).End(xlDown).Offset(1, 0), Cells(50, 36)).Select

or

Range(Range("A1").End(xlDown)(2, 1), Range("AJ50")).Select