Can anyone teacher me how to store non null data of arbitrary selection area from worksheet to a two-dim array? very appreciate
Can anyone teacher me how to store non null data of arbitrary selection area from worksheet to a two-dim array? very appreciate
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?
Be as you wish to seem
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
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?
Be as you wish to seem