Hi There,
I am trying to create an array Btarray from copying the value in the range A5:C8 in my worksheet. I will like this to be dynamic which can be increased or decreased in terms of rows (for example A5:C17 or A5:C7).
I am having two challenges 1). how to ignore the empty cells before my array begins 2) Ending the array when after the blank cells.
So far I have this.
Please Login or Register to view this content.
Bookmarks