ExcelBanter - redim

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - redim (https://www.excelbanter.com/excel-programming/415147-redim.html)

ranswrt

redim

How do I count how many times a value is in a range to redim an array to that
size?
Thanks

[email protected]

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

ranswrt

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

All times are GMT +1. The time now is 02:50 AM.