Populate range while only knowing the starting cell

[gnome_core]

Hello,

I have several blocks of data in an excel sheet. I want to populate an Array for each block of data. The number of rows are dynamic but there are always going to be 2 columns. I'm able to find the starting cell of the block of data from a function. This function returns the cell address ($A$6). How can I loop through the block of data until I hit an empty cell while populating the Array?

I found this code, but I'm not exactly sure how to modify it for my needs.

Please Login or Register  to view this content.

I realize that I can use

Please Login or Register  to view this content.

But I want to stay away from using SELECT as I have read it is bad to use.

Many thanks,
J

[Leith Ross]

Hello gnome_core,

This code will set the range from the starting cell address to the last entry before a blank cell in the range.

Please Login or Register  to view this content.