Problems to store visible cells into array

Hello to all,

Please some help on this.

I'm trying to store into an array the values of filtered/visible cells in range A2:A10. With the code below
the array only is loaded with the first 3 values (B,C,D), where should be B, C, D, T, K.

The filter is applied based on those cells colored in red.

I'm attaching a sample file for your reference.

Please Login or Register  to view this content.

Thanks in advance.

Filtered (Visible) cells can only take contagious cells, which means the array can only take two rows at most, but you can set it to a range.

Hi AB33,

Thanks for answer.

I've tried setting to range but when I see the content of "rng" in "Locals" windows it's still only taking the first 3 filtered values.

I've done as below.

Please Login or Register  to view this content.

I have ameended your code. I have also added my own code.

Originally Posted by cgkmal

I've tried setting to range but when I see the content of "rng" in "Locals" windows it's still only taking the first 3 filtered values.

I've done as below.

Please Login or Register  to view this content.

Array can store continuous block of cells.
That means it is equivalent to

Please Login or Register  to view this content.

So, if you want all the filtered value in an array, you need to copy the filtered data in somewhere then store in an array.

deleted duplicate

Thank you. Understood.

One more question.

How to set an "if condition" to chek if in the range A1:A10 there is no cells colored in red?

Thanks again.

One way

Please Login or Register  to view this content.

Thanks jindon for the example. Exactly to understaand how to set that condition and some other very good techniques you always use.

Regards

No problem.