how to store arbitrary selection area to two-dim array

[Garcia]

Can anyone teacher me how to store non null data of arbitrary selection area from worksheet to a two-dim array? very appreciate

[Aflatoon]

What do you want to do if there is null data in a cell - i.e. an empty cell? Also, would you count a cell that returns "" as the result of a formula as null?

[Garcia]

Aflatoon, thanks, i do not want to consider empty cell and the result of a cell formula is null ,but if result is not null ,formula cell result is consider.can you give me your advice or coder? it will help me

[Aflatoon]

So how do you want to adjust the array? Say the second cell down in the first column is blank, do you want to move the rest of that column up one in the array, or the rest of that row left, or something else?