View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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