Selecting a range above the blank - macro

[PotatoBrado]

Is there a simple way to select a range from the currently selected cell down to the cell directly above a blank?
I'm writing a macro where I've found the first cell in a column that I need, but I haven't figured out how to do a "Shift + Select" down to the cell above the next blank cell.
It can't be a specific range down to like "A15" or something because with each set of numbers I use the number of rows with data will change.

Any help would be appreciated! Thanks!

 

[Norie]

Perhaps.

Range(ActiveCell, ActiveCell.End(xlDown).Offset(-1)).Select

 

[PotatoBrado]

I've been trying to find a variation on what you just posted. For some reason what you wrote grabs more than just down to the next blank cell.

 

[Norie]

Do you have merged cells?

 

[PotatoBrado]

And how to edit a post. You all can't see my desktop. I'll figure this internets out one way or another.

 

[PotatoBrado]

Nope!

 

[PotatoBrado]

https://drive.google.com/file/d/169vH-fYhqRhmUJFeryaHXaSgcsP3g1jt/view?usp=sharing

 

[Fluff]

In an unused cell type
=isblank(A23)
Change the A23 to reflect one of the "blank" cells, what does it say?

 

[PotatoBrado]

Ultimately, I'm trying to select the cells pictured. Then eventually the next set. And the next set.

The =isblank function returns a 0.

 

[Fluff]

Isblank should have returned either True or False, but either way those cells are not blank.