| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rows in a Range
I have selected a column and called it "Mark" I need to determine the number
of rows in this column with values in them at runtime. The number of rows used in this column will vary. How do I determine the number of rows with values? If I use Range("Mark").Rows.Count it appears to return a very large number. thank you mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
| Not listing more than a range of rows | Excel Worksheet Functions | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| group rows in a range based on criteria from another range (vba) | Excel Programming | |||
| How to subtract some rows from a range | Excel Programming | |||
![John Smith[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
