If Empty run Macro

  • Thread starter Thread starter Miree
  • Start date Start date
M

Miree

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
 
Hi,

Maybe this

Sub Sonic()
Set myrange = Range("G5:H5")
If Application.CountA(myrange) Then
moveresults2
Else
moveresults
End If
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Datavalidation with shrinking non blank values 1
Run Macro If Cell have "x" value 0
VBA set thick borders around non empty cells in range 0
Code help 0
Excel formula, sum the value cell and if empty cell left blank 0
Macro to "find" the next empty cell in a range 2
Is there an Excel Function that can be used in lieu of this formul 5
COPY FORMULA TO THE LAST CELL 2

Back
Top