vba_beginner
New Member
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 return $1:$16384 or $A:$XFD instead? I can't think of a workaround, and would like to know if anyone has a suggestion.
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 return $1:$16384 or $A:$XFD instead? I can't think of a workaround, and would like to know if anyone has a suggestion.