Thread: Macro Range Selection
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roy A.[_2_] Roy A.[_2_] is offline
external usenet poster
  
Posts: 7
Default Macro Range Selection
r = ActiveCell.Row
Range("A" & r & ":C" & r).Select

Thank you Gary, this worked perfectly.
Reply With QuoteReply With Quote