Thread: How do i select the coordinates of the first column & last row in a pasted range
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default 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
Reply With QuoteReply With Quote