ExcelBanter - .End(xlRight)).Select Doesn't Work

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - .End(xlRight)).Select Doesn't Work (https://www.excelbanter.com/excel-programming/322980-end-xlright-select-doesnt-work.html)

Madcatrobert

.End(xlRight)).Select Doesn't Work

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

Trevor Shuttleworth

.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

Dick Kusleika[_4_]

.End(xlRight)).Select Doesn't Work

It needs to be xlToRight

?xlright
-4152
?xltoright
-4161

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Madcatrobert wrote:
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?

All times are GMT +1. The time now is 03:29 PM.