Thread: Find value in bottom cell in a column
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] markwalling@gmail.com is offline
external usenet poster
  
Posts: 5
Default Find value in bottom cell in a column
what about the used property?

Don Guillett wrote:
Sub findlastvalue()
lr = Cells(Rows.Count, "a").End(xlUp).Row
MsgBox Cells(lr, "a")
End Sub

--
Don Guillett
SalesAid Software

"JaMark" wrote in message
oups.com...
Oops, forgot to mention that it should be in VBA, sorry about that...

Example:

Bollard X Coord Y Coord Z Coord
m m m
A -10 4 -1
B -8 4 -1
C 7 4 -1
D 9 4 -1
E 11 4 -1


The returned value should be "E" (in VBA)


Reply With QuoteReply With Quote