Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am running Excel 2003.
I have data which looks like this A B C D E F G 1 Title on all columns 2 A2 B2 C2 D2 E2 F2 G2 3 A3 B3 C3 D3 E3 F3 G3 4 A4 B4 C4 D4 E4 F4 G3 5 A5 B5 C5 D5 E5 F5 G4 6 A6 B6 C6 D6 E6 F6 G6 .... I record a macro which hides row 1 and selects column C. When I step through the code, the whole sheet seems to be selected. I have a workaround; I would like an explanation. Rows("1:1").EntireRow.Hidden = True ' Hide first row Columns("C:C").Select ' "selects" Columns("A:G") Range("C2", Range("C2").End(xlDown)).Select ' "selects" what I want. -- Walter Briscoe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Pause recorded macro for user selection of menu option | Excel Programming | |||
Recorded macro | Excel Discussion (Misc queries) | |||
Recorded single column insert in macro. Macro inserts two not one | Excel Programming | |||
Creating a macro which presses a button containing a recorded macro | Excel Programming |