| 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 | |||
Hybrid Mode
