Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting a range of cells
I am working in VBA and am still trying to select ranges.
This statement works to select all the rows that are used in columns A to C Set rng = Range("A1:C" & Cells(Rows.Count, "C").End (xlUp).Row) rng.Select I am trying to select all the rows from 3 on down in columns N and O. This does not work as it only gets through row 32. What am I missing? Set rng = Range("N3:O3" & Cells(Rows.Count, "O").End (xlUp).Row) rng.Select |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting a range of cells
Barb,
Try changing: Set rng = Range("N3:O3" & Cells(Rows.Count, "O").End(xlUp).Row) to Set rng = Range("N3:O" & Cells(Rows.Count, "O").End(xlUp).Row) Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting a range of cells, how to ? | Excel Worksheet Functions | |||
Range selecting cells | Excel Discussion (Misc queries) | |||
Selecting a Range Of Cells. | Excel Programming | |||
Help with selecting a range of cells | Excel Programming | |||
Selecting a range of cells | Excel Programming |