Application-defined or object defined error
 

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

Application-defined or object defined error
 

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

--
Regards,
Tom Ogilvy

"teresa" wrote in message
...
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

Application-defined or object defined error
 

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



In article ,
teresa wrote:

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