Where did B1 come from?
This will look DOWN from the activecell. If in cell b1 it will look ONLY in
column B, A looks in A, etc.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Stan Brown" wrote in message
t...
Mon, 16 Jul 2007 11:07:40 -0500 from Don Guillett <dguillett1
@austin.rr.com:
How about a macro?
Sub nextnonblankvalue()
MsgBox ActiveCell.End(xlDown)
End Sub

Suppose A1 through D1 are non-empty, and E1 is empty. If you're in
A1, won't the above macro return D1 instead of the wanted B1?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/