Hello,
If you use the sub:
Sub ShowRows()
MsgBox Rows.Address
End Sub
a Message Box will appear with the value $1:$1048576 in Excel 2010. However, if you change the sub from Rows to Columns:
Sub ShowColumns()
MsgBox Columns.Address
End Sub
it returns the same value. Shouldn't it...