Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i select the coordinates of the first column & last row in a pasted range
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i select the coordinates of the first column & last row ina pasted range
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i select the coordinates of the first column & last row in a pasted range
You can get the address with this one-liner....
LastRowFirstColAddress = Selection(1)(Selection.Rows.Count).Address(0, 0) -- Rick (MVP - Excel) "Luc" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i select the coordinates of the first column & last row in a pasted range
And if you want to select that cell, just do this...
Selection(1)(Selection.Rows.Count).Select -- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... You can get the address with this one-liner.... LastRowFirstColAddress = Selection(1)(Selection.Rows.Count).Address(0, 0) -- Rick (MVP - Excel) "Luc" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i select the coordinates of the first column & last row in a pasted range
Perfect , thanxxxxs for all the help.
If i hadn't you guys....... Luc "Rick Rothstein" schreef in bericht ... And if you want to select that cell, just do this... Selection(1)(Selection.Rows.Count).Select -- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... You can get the address with this one-liner.... LastRowFirstColAddress = Selection(1)(Selection.Rows.Count).Address(0, 0) -- Rick (MVP - Excel) "Luc" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select Worksheet Where Data is Pasted | Excel Programming | |||
select a range in a column | Excel Discussion (Misc queries) | |||
Select range between column and row | Excel Programming | |||
Select column same row by range name | Excel Programming | |||
select date range in column | Excel Worksheet Functions |