| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA to obtain Max Rows in any column in Used Reange
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| repeat a formula same column same number of rows apart | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
| moving alternating rows to a column with the order staying the sam | Excel Discussion (Misc queries) | |||
Threaded Mode
