Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selection problem with recorder
My data distribution looks like this:
Col1 Col2 Col3 -------- Col20 Col21 Col22 Col23 data1 data3 -------- data20 data23 Using the Macro recorder , I selected data1 to data23, by pressing Ctrl-Shift and the right pointing arrow (=) three times. The relevent codes generated are as follows: Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select However, when I executed them, Excel carried out the first line correctly but stepped over the last two lines without carrying them out. What's wrong? There will always be 3 blank columns, but more columns will be added after Col20 to accept more data. Hence, Range("A1:W1").Select can't be used. Any suggestion is much appreciated. Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with MS Community Newsgroups? | Excel Discussion (Misc queries) | |||
Finding a Problem Link in Excel | Excel Discussion (Misc queries) | |||
Problem with Pasting Data | Setting up and Configuration of Excel | |||
strange problem with links updates in excel | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |