Basically, I want to be able to store in a variable of the current range which changes as it goes down the
spreadsheet, to be able to store the Start:finish cell reference to use as a named range formula,
and save the named range with the content of the cell of the first row/column of the range.

Be grateful for any assistance, I have tried to search to do this but cannot find any examples which match my issue