any techies able to help Excel Vba

May 20, 2003
15
0
11
#1
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:
Jun 30, 2003
1
0
11
#3
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


:)