Thread: Find value in bottom cell in a column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JaMark JaMark is offline
external usenet poster
  
Posts: 7
Default Find value in bottom cell in a column
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