|I'm confused by your question.|
There are 3 common methods for working with a range in VBA:
1 - Using hardcoded strings e.g. Range ("B1:AG5")
2 - Calculating the range e.g.
Range ("B1:AG" & row_num)
Range(Cells(row_num1, col_num1), Cells(row_num2, col_num2))
Range(Cells(row_num1, "B"), Cells(row_num2, "AG"))
There are a number of different syntaxes that can be used for this, but the point is that you can build the range by using variables or values from a cell in a worksheet, etc.
3 - Using Named ranges, which can be static or dynamic.
Therefore when you ask Is there a way that I can select the range without using the row and column numbers, rather than (B8:AG626)? I'm not sure how to answer.
You say Is there a way that I can select the range without using the row and column numbers which tells me you don't want to use row and column numbers, but you also say rather than (B8:AG626) which also implies you don't want to hardcode the ranges. That's 2 negatives, isn't it?