any techies able to help Excel Vba

[V. III]

any techies able to help Excel Vba..bonsai??

Can someone possibly help:

I need the macro to go to a certain column of numbers(eg.A1:A10), then figure out which is the first non-zero number in that column(eg "A8"). Then make the active cell, a cell which is 1 row down and one coulmn to the right of that cell.(i.e"B9").

Any help would be appreciated.

Thanks.

 

[fazalv]

Contact Bonsai.
He is our resident excel guru among others.

 

[simonking]

This appears to work:-

Sub findcell()

For Each x In Range("a1", "a10")
If x.Value > 0 Then
Cells(x.Row + 1, x.Column + 1).Activate
Exit For
End If
Next

End Sub


🙂

 

[V. III]

Simon, Thanks Mate!