Thread: selecting current row plus the 2 above
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
  
Posts: 2,494
Default selecting current row plus the 2 above
maybe this?

ActiveCell.Offset(-2).Resize(3).EntireRow.Select

--


Gary

"RocketRod" wrote in message
...
Can someone show me the code to select the current row and the 2 above it?


Reply With QuoteReply With Quote