VBA to select a range from active cell to a border

[gdowgial]

Hi,

I am looking for VBA code that can select a range from the currently active cell down to the next border.

There are random blank cells in the column, which prevents me from being able to 'select all' to the next blank cell.

There are multiple tables, which vary in size and are arranged vertically within the worksheet (each table needs to be analyzed individually). This prevents me from using <code>[.End(xlUp).Select]

Any help would be greatly appreciated.

Thanks
</code>