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

[Guest]

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?

 

[Trevor Shuttleworth]

I think it need to be:

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

Regards

Trevor

 

[Dick Kusleika]

It needs to be xlToRight

?xlright
-4152
?xltoright
-4161