• Scheduled Maintenance - Thursday, March 30th at 9:00am UK (4:00am EST) the Trade2Win website will be inaccessible for up to 2 hours whilst we perform some essential maintenance. Further updates will be posted in the T2W Website Updates thread.

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:

simonking

Newbie
Messages
1
Likes
0
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
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