Selection.End(xlDown) works from the first cell in the selected range...
--
Festina Lente


"kirke" wrote:

Thx! This perfectly work!

Well then, don't you the reason know why mine doesn't work? it looks
similar with yours~~


PapaDos wrote:
Range("C1", Range("C1").End(xlToRight).End(xlDown).End(xlDown) ).Select

--
Festina Lente


"kirke" wrote:

I want to select columnes from C to unknown.
Thus, I want to define it like following:

Range("C1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlDown)).Select

However, it doesn't work properly, The result is

Range("C1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select

Thus, I record the macro and replay it. However, also doesn't work.
Sometimes, it works, and suddenly it doesn't work. and that's now. It
makes me crazy !
Is there some setting for using this? Or is there other method?
I always appreciate peoples answer from here! It's really really
helpful!!!!!
Thx.