Need Explanation on Ranges and Array

[Karthik Sen]

Hi All,

Kindly look into the attached excel and please explain the given codes about ranges and array

[AB33]

This appears to my code. Look-at the explanation code.

[Karthik Sen]

Thanks for the explanation...

Can you also explain how the Resize function given in the code works..

[AB33]

Resize was the most difficult concept to understand while I was learning VBA.

Please Login or Register  to view this content.

It means increase(Expand) from D2 by the value of k (rows) and column 1.
If the value of k is 20, you are streching the value of y from D2 to 20 and just a single column.

[Karthik Sen]

Thanks a lot !!!!!