| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
redim
How do I count how many times a value is in a range to redim an array to that
size? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
redim
On Aug 5, 10:41*am, ranswrt wrote:
How do I count how many times a value is in a range to redim an array to that size? Thanks You could use the Countif worksheet function... so you would enter it in VBA as application.worksheetfunction.countif( The Range , The Value). Using this method the range would be the same the VBA range so application.worksheetfunction.countif( Range("E:E") , 15 ) = how many time 15 appears in column E. Hope that helps, James |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
redim
Thanks
" wrote: On Aug 5, 10:41 am, ranswrt wrote: How do I count how many times a value is in a range to redim an array to that size? Thanks You could use the Countif worksheet function... so you would enter it in VBA as application.worksheetfunction.countif( The Range , The Value). Using this method the range would be the same the VBA range so application.worksheetfunction.countif( Range("E:E") , 15 ) = how many time 15 appears in column E. Hope that helps, James |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ReDim Array | Excel Programming | |||
| ReDim Matrix | Excel Programming | |||
| ReDim Array | Excel Programming | |||
| Dim and Redim | Excel Programming | |||
| redim preserve | Excel Programming | |||
Linear Mode
