Thread: Range going up the column instead of down
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Range going up the column instead of down
do while activecell.row 3
activecell.offset(-1,0).Select
Loop

--
Regards,
Tom Ogilvy


"jsd219" wrote in message
ps.com...
Does anyone know how to set a range that will travel up the column from
the active cell until it hits a cell you specify?

God bless
jsd219



Reply With QuoteReply With Quote