redim

  • Thread starter Thread starter ranswrt
  • Start date Start date
R

ranswrt

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

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
 
Thanks

[email protected] said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Redim on 2 dimensional array 7
Arrays [Why does this not work?] 11
is array redimmed? 5
Array range error question 1
Values in a array are disappearing 2
Arrays/Redim/Help! 1
Redim preserve does not work for me 4
ReDim not working as expected. Array expert needed. 16

Back
Top