Thread: selecting current row plus the 2 above
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default selecting current row plus the 2 above
hi
try this...
Range(ActiveCell.EntireRow, ActiveCell.Offset(-2, 0)).Select

regards
FSt1

"RocketRod" wrote:

Can someone show me the code to select the current row and the 2 above it?
Reply With QuoteReply With Quote