VBA select cell with a specific value and all cells below until blank

Originally Posted by hrlngrv

If the section always start in row 413, and you want column A,

Dim rng As Range
':
Set rng = Worksheets("some_sheet").Range("A413")
If Not IsEmpty(rng.Offset(1, 0).Value) Then Set rng = Range(rng, rng.End(xlDown))

Unfortunately the number of rows above changes every week as well, so the section does not always start at 413. I believe I got a good answer already. I appreciate you, and will save your input in my bag of tricks!

Have a great day.