From: Luc on
Perfect , thanxxxxs for all the help.
If i hadn't you guys.......

"Rick Rothstein" <rick.newsNO.SPAM(a)> schreef in bericht news:eHDTXybfKHA.5608(a)TK2MSFTNGP05.phx.gbl...
And if you want to select that cell, just do this...


Rick (MVP - Excel)

"Rick Rothstein" <rick.newsNO.SPAM(a)> wrote in message news:uXwHQtbfKHA.1824(a)TK2MSFTNGP04.phx.gbl...
You can get the address with this one-liner....

LastRowFirstColAddress = Selection(1)(Selection.Rows.Count).Address(0, 0)

Rick (MVP - Excel)

"Luc" <lferr(a)> wrote in message news:OpE7IabfKHA.300(a)TK2MSFTNGP02.phx.gbl...
When i have a range pasted to a worksheet, how do i retrieve the coordinates of the last row, first column of this range (the range contains empty cells).

Example of a range : B3:F32 => the result shuld be B32

The range is not fixed, it could contain 1 row to ..... rows
PS : The range is pasted and selected

Thanx for your help.