| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Empty run Macro
I want to write code to say that if range G5:H5 is empty run macro
moveresults, if it is not empty run macro moveresults2. Thank You |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If Empty run Macro
Hi,
Maybe this Sub Sonic() Set myrange = Range("G5:H5") If Application.CountA(myrange) Then moveresults2 Else moveresults End If End Sub "Miree" wrote: I want to write code to say that if range G5:H5 is empty run macro moveresults, if it is not empty run macro moveresults2. Thank You |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If cell is empty then run macro otherwise skip this macro | Excel Programming | |||
| Macro to empty row | Excel Programming | |||
| Delete Row If Empty Macro | Excel Discussion (Misc queries) | |||
| macro only run if cell is not empty | Excel Programming | |||
| macro to colour empty cells (cells not recognized as empty) | Excel Programming | |||
Linear Mode
