Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select range
hi,
i have the following: Range("A5000").End(xlUp).Offset(0, 0).Select the only problem is this is being run when the sheet is in Autofilter mode. I want the range to be selected, except for the header row. How can i modify this? thanks in advance, geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
select range
I take it that your header row is in row 1 (A1):
Range(Range("A2"), Range("A500").End(xlUp)).Select Also, you don't need Offset(0, 0). This does nothing unless one of the values in the parenthesis is less than or greater than 0. Alan "geebee" wrote: hi, i have the following: Range("A5000").End(xlUp).Offset(0, 0).Select the only problem is this is being run when the sheet is in Autofilter mode. I want the range to be selected, except for the header row. How can i modify this? thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
Find End in Undefined Range Select Range Trim | Excel Programming | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
Select Sheet then Select Range | Excel Programming |