Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Address, a read-only property, displays the cell address for a Range object in absolute notation (a dollar sign before the column le

Sub cellAddress()     MsgBox range(cells(1, 1), cells(5, 5)).Address End Sub