any techies able to help Excel Vba

This is a discussion on any techies able to help Excel Vba within the Techies Corner forums, part of the Trading Career category; Can someone possibly help: I need the macro to go to a certain column of numbers(eg.A1:A10), then figure out which ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Sep 18, 2003, 5:26pm   #1
Joined May 2003
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 by V. III; Sep 18, 2003 at 6:27pm.
V. III is offline   Reply With Quote
Old Sep 18, 2003, 5:42pm   #2
 
fazalv's Avatar
Joined Feb 2003
Contact Bonsai.
He is our resident excel guru among others.
__________________
"Give a man a fish, and feed him for a day - teach him how to fish, and feed him for a lifetime!"
fazalv is offline   Reply With Quote
Old Sep 19, 2003, 6:59am   #3
 
simonking's Avatar
 
1 Posts
Joined Jun 2003
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


simonking is offline   Reply With Quote
Old Sep 19, 2003, 9:51am   #4
Joined May 2003
V. III started this thread Simon, Thanks Mate!
V. III is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hey, Techies......Reality Check ducati998 Psychology, Risk & Money Management 149 Jul 21, 2005 3:11pm
Guide: T2W Guide to Trading : Techies Corner rossored Techies Corner 5 Feb 14, 2005 7:51am
excel aarie5 Trading Software 9 Dec 3, 2004 11:34pm
For the real Techies wysinawyg Techies Corner 7 Jun 30, 2003 8:04am

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)