Thread: Running a macro if a cell contains number 1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aidan[_2_] Aidan[_2_] is offline
external usenet poster
  
Posts: 3
Default Running a macro if a cell contains number 1
I have a macro that I activates if I click on a check box. It copies rows,
Can someone please give me the additional code I need at the start so the
macro only runs if the content of a specified cell in the Testing Combined
sheet is 1.

The code I have so far is
Sheets("Skills Required").Select
Rows("63:65").Select
Selection.EntireRow.Hidden = False
Sheets("Testing Combined").Select
Range("D159").Select
Reply With QuoteReply With Quote