| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select all rows except header row in one column
Hi,
I've got the following code to select all data apart from the header row... with activesheet .rows("2:" & .rows.count).select end with How do I select all data in a certain column apart from the header row without selecting right doen to the bottom of the sheet? Thanks, Mel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to select rows to average based on a value in a different column | New Users to Excel | |||
| Select max value in a row and pick the column header | Excel Discussion (Misc queries) | |||
| Select multiple rows and add a value in a column | Excel Programming | |||
| how would i select a group of rows based on a column value | Excel Programming | |||
| Select rows contain Xin Column Y | Excel Programming | |||
Threaded Mode
