Try:

Sub Temp
Range("A1").Select
If range("A1").Value0 Then
ActiveCell.Offset(0,1).Select
End If
End Sub

"thop" wrote:

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?