Thread: selecting a range of cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GaryDK GaryDK is offline
external usenet poster
  
Posts: 13
Default 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 With QuoteReply With Quote