Thread: .End(xlRight)).Select Doesn't Work
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
  
Posts: 1,089
Default .End(xlRight)).Select Doesn't Work
I think it need to be:

Range(Range("A5"), Range("A5").End(xlRight)).Select

Regards

Trevor


"Madcatrobert" wrote in message
...
When I use Range("A5", Range("A5").End(xlRight)).Select, I get an error
"Application-defined or object-defined error". Substituting xlUp or xlDown
works correctly.

Any suggestions?
--
TIAFYH
mcr


Reply With QuoteReply With Quote