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

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)?

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)

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)

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)

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

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)

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)