How do i select the coordinates of the first column & last row in a pasted range
in [Programming]
|
From: Luc on 15 Dec 2009 14:34 Perfect , thanxxxxs for all the help. If i hadn't you guys....... Luc "Rick Rothstein" <rick.newsNO.SPAM(a)NO.SPAMverizon.net> schreef in bericht news:eHDTXybfKHA.5608(a)TK2MSFTNGP05.phx.gbl... And if you want to select that cell, just do this... Selection(1)(Selection.Rows.Count).Select -- Rick (MVP - Excel) "Rick Rothstein" <rick.newsNO.SPAM(a)NO.SPAMverizon.net> 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)base.be> 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. Luc
First
|
Prev
|
Pages: 1 2 Prev: Restrict cells selected to specific range name Next: visual c# excel 2007 pivot filter |