Menu

Find value in bottom cell in a column

Search this Thread

Prev

Previous Post

Next Post

Next

#7

Report Post

Posted to microsoft.public.excel.programming

Don Guillett Don Guillett is offline

Don Guillett is offline

external usenet poster

Posts: 10,124

Default

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)

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I reference contents of a cell at the bottom of a column?	MarkB	Excel Worksheet Functions	2	April 9th 09 12:19 PM
show last used cell in a column at the bottom of column.	dsharris59	Excel Worksheet Functions	3	February 4th 09 07:09 PM
Find the bottom cell that contains a specific val in a range?	amit	Excel Worksheet Functions	2	January 24th 07 05:23 PM
dislike jump bottom of column by double-clicking the bottom of cel	Joe	Excel Discussion (Misc queries)	1	April 9th 06 09:27 PM
Shortcut to move to bottom (last) cell in a column	Frustrated	Excel Discussion (Misc queries)	1	September 21st 05 03:47 AM

All times are GMT +1. The time now is 12:58 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement