Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Change from Column Selection to Cell Selection | Excel Programming | |||
Object Type of a selection... counting rows in a selection | Excel Programming | |||
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming |