Index on a selection

Hi folks.

First time here, hope you can help me.

I'm trying to get a index on a for each next routine but I don't know how to do it. Like the Item method. In the example I want the statement to run on the last cell of the selection.

Example:

Sub Example()
For each cell in selection

if cell.index = selection.count then
statement
endif

next

end sub

Thanks for any help you can give.

Best regards,
KiO