Assign discrete range values to array variable

[karan]

Hello All,

I want to assign values from a discrete range to an array variable. For example, I want my variable named 'myarray' to be assigned values of A1:A5, A10:14, A25:A26 of Sheet1.

Anyone has ideas?

Thanks,
Karan

[Ron Coderre]

Here's an example to experiment with:

Please Login or Register  to view this content.

Is that something you can work with?

[karan]

Hi Ron,

I have a very large dataset of around 50000 rows and based on some logic I have to choose some designated discrete range. I was looking for a faster way to achieve this. But, I just figured that I can perform some arithmetic operations on the range itself (rng). So, I'm now using this code:

Please Login or Register  to view this content.

Thank you so much for helping out.

Regards,
Karan