View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grandma Barb[_3_] Grandma Barb[_3_] is offline
external usenet poster
 
Posts: 1
Default 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