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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selection problem with recorder
Range(Cells(1,1),Cells(1,"IV").End(xltoLeft)).Sele ct
-- Regards, Tom Ogilvy "Brian" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selection problem with recorder
"Tom Ogilvy" wrote in message
... Range(Cells(1,1),Cells(1,"IV").End(xltoLeft)).Sele ct This is ok if data1 is in Row 1. Sorry for not being more specific. My data1 can be in any random row location, resulting from a sort. Therefore, I need to select from the position of the active cell across to the right. Thanx Brian -- Regards, Tom Ogilvy "Brian" wrote in message ... 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 |
Reply |
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) |