如何在列中定义一个已知的第一个单元格，并在特定的值单元格之前结束的范围

I am trying to define a variable column range that will be set with a first cell being known and the last cell being one cell above the cell containing "Net Amount" I am trying to define a variable column range t