any techies able to help Excel Vba

V. III

Junior member
Messages
15
Likes
0
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.
 
Last edited:
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


:)
 
Top