How do i select the coordinates of the first column & last row in a pasted range
Thanx Benito,
What code should i use to move to this last cell + 1 row lower ?
And make this the active cell.
In my Example that would be B32 + 1 row = B33
"Benito Merino" schreef in bericht
...
On 15 dic, 19:42, "Luc" wrote:
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.
Luc
Hello.
One way is:
Sub lastrowfirstcolumn()
With Selection
first_column = .Column
last_row = .Row + .Rows.Count - 1
coord = Cells(last_row, first_column).Address
End With
End Sub
Regards,
Benito
Barcelona
|