Column and row references of range
 

Michael Allen wrote:

Is is possible to determine the extent column and row references of a
temporarily selected ranges of cells in code, ie top left and bottom right?
Cells within the range may contain blanks.

Thanks
Mike


Set rng = Range("aaa1")
MsgBox rng(1, 1).Address & ":" & rng(rng.Rows.Count, _
rng.Columns.Count).Address

Alan Beban

Column and row references of range
 

Is is possible to determine the extent column and row references of a
temporarily selected ranges of cells in code, ie top left and bottom right?
Cells within the range may contain blanks.

Thanks
Mike