any techies able to help Excel Vba


Junior member
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.

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

End Sub

AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock    No Thanks