Find value in bottom cell in a column
 

Quick question. How do I get the value of the bottom cell in a certain
column (actually always column A)?

Find value in bottom cell in a column
 

use match to find the row of any number larger than possible in your column
and index to give you the value in that row. Use "zzzzzzzzzz" for text.
=INDEX(A:A,MATCH(99999999999999,A:A))

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
Quick question. How do I get the value of the bottom cell in a certain
column (actually always column A)?

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)

Find value in bottom cell in a column
 

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)

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)

Find value in bottom cell in a column
 

And what should be written in the parentheses when I want to use the
function?

Find value in bottom cell in a column
 

I don't understand you question. Which property?

wrote:
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)

Find value in bottom cell in a column
 

If you mean usedrange, OP asked for col A

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
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)