If/Then statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know if or how to setup a macro that will look at a cell and if it has a value greater than 0, then the cursor would go to the next cell to the right?
 
Try:

Sub Temp
Range("A1").Select
If range("A1").Value>0 Then
ActiveCell.Offset(0,1).Select
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

Change_Event troubles, no error & no work. 6
Excel Need Countifs Formula Help 0
Run Macro If Cell have "x" value 0
Arithmetic with Cell Dates 1
Macro ignores IF statement that refers to cell value 1
Perplexing IF statement 4
VBA set thick borders around non empty cells in range 0
Audible Alarm 11

Back
Top