D
donoteventry;removes;pam
Excel 2003
What approach in VBA to get the maximum number of rows of actual data in any one column.
I do know how to get Rows & Columns in the Used Range - but I need cells with data not cells with
formatting.
My mind does not work well in the 3rd dimension - i.e. arrays.
The consepts which come to mind are MAX() and Array() and .End()
Can anyone help?
Thanks!
EagleOne
What approach in VBA to get the maximum number of rows of actual data in any one column.
I do know how to get Rows & Columns in the Used Range - but I need cells with data not cells with
formatting.
My mind does not work well in the 3rd dimension - i.e. arrays.
The consepts which come to mind are MAX() and Array() and .End()
Can anyone help?
Thanks!
EagleOne