Thread: Macro to select cells at current cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
excel-ant excel-ant is offline
external usenet poster
  
Posts: 26
Default Macro to select cells at current cell
Hi Amy,

You certainly can
==========================================
Sub Hide3Rows()

qrow = ActiveCell.Row
Rows(qrow & ":" & qrow + 2).EntireRow.Hidden = True

End Sub
==========================================
Ant
http://www.excel-ant.co.uk
Reply With QuoteReply With Quote