Thread
:
Bypas Nil Values
View Single Post
#
9
Posted to microsoft.public.excel.programming
a m spock
external usenet poster
Posts: 50
Bypas Nil Values
don,
you can't imagine how grateful i am.
am
"Don Guillett" wrote:
Just in case.
mc="f" refers to column F. change to suit.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"a m spock" wrote in message
...
sorry fro prev post. just figured it out.
thanks again!!!
"Don Guillett" wrote:
One way
Sub gotolastpostitivevalue()
mc = "f"
For i = Cells(Rows.Count, mc).End(xlUp).Row To 2 Step -1
If Cells(i, mc) 0 Then
Cells(i, mc).Select
Exit Sub
End If
Next i
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"a m spock" wrote in message
...
the data in the computed column on sales completed is something like
this.
the data is dynamic and changes as each transaction is added to the
workshet.
i need a macro which will, starting from anywhere on the worksheet take
the
cursor to the cell with the last positive value i.e. 800,000
Trades Completed
0
200,000
1,000
1,000,000
0
0
0
0
800,000
0
0
0
Reply With Quote
a m spock
View Public Profile
Find all posts by a m spock