Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pick last item from a (variable) range
Hi all,
Is there a formula to pick the last item out of a (variable) range thanks in advance Gert |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pick last item from a (variable) range
How do you mean pick
This piece of code will store and display the last cell in a selected range(x) Sub LastCell() For Each cell In Selection cell.Select: x = ActiveCell.Value Next cell MsgBox x End Sub http://www.excel-ant.co.uk |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pick last item from a (variable) range
Gert wrote: Hi all, Is there a formula to pick the last item out of a (variable) range thanks in advance Gert How about this: x(x.Rows.Count, x.Columns.Count).Value where x is your range? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I select more than one item from a drop down pick list? | Excel Discussion (Misc queries) | |||
How do I select more than one item from a drop down pick list? | Excel Worksheet Functions | |||
Automatically executing a macro when A pick list item is selected | Excel Programming | |||
loop through cells in a range and pick up corresponding cell values in another range | Excel Programming | |||
ListBox (arrow keys pick each item) | Excel Programming |