| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running a macro if a cell contains number 1
If Range("D159").Value < 1 Then
Exit Sub End If -- Gary's Student gsnu200711 "Aidan" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running macro from currently selected cell? | Excel Discussion (Misc queries) | |||
| Running Macro when a cell value changes | Excel Discussion (Misc queries) | |||
| Running a Macro a number of times | Excel Discussion (Misc queries) | |||
| running a macro when a certain cell changes | Excel Programming | |||
| Running a macro when a cell value changes | Excel Programming | |||
![Aidan[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
