Select dynamic cell range based on blank value not formula in VBA

[eastrand]

I have a worksheet that has formulas from A7:D100. These formulas return values to a certain point(dynamic) and then returns "" the rest of the way down. I'm looking for a way in VBA to detect where the first row is with "" and then selecting A7:D??(whatever the first "" row). This selection will then be stored into a variable to be used elsewhere. So far, everything I find that searches for blank cells goes all the way to row 101 because there are formulas to row 100. I need something that will look for "" or blank cell values and not formulas. Any help on this is much appreciated.

	A	B	C	D
6	Date	Customer	Quantity	Total
7	1/1/2019	Cust1	12	$23.32
8	1/3/2010	Cust2	24	$52.23
9	1/6/2019	Cust3	10	$20.53
10	""	""	""	""
11	""	""	""	""
12	""	""	""	""
13	""	""	""	""

<tbody>
</tbody>

 

[MARK858]

Maybe....

Range(Range("A7"), Columns("D").Find("*", , xlValues, , xlByRows, xlPrevious).Offset(1)).Select

although it would be more normal to be selecting to the row above the first row with "".

 

[MARK858]

Actually I was a bit OTT with the use of Range so...

Range("A7", Columns("D").Find("*", , xlValues, , xlByRows, xlPrevious).Offset(1)).Select

 

[eastrand]

Wow! I've been searching on and off for this for over a year. I had something close but I was missing the *. Thank you, it worked perfectly.
​

 

[eastrand]

BTW, the reason I need the first row with the "" included is because a couple of the columns have a total at the end.