Normally we define a range bay the row & column of the begin and end cell, e.g.
I wonder if there is a way to define the range which has
end-of-column marker, e.g.
~ stands for
End-of-column cell is the cell which has the maximum index of row in the current column - the last cell with
actual value in the column.
It would be lovely to have this marker in Excel since we can have defined-name range which auto expands whenever the sheet grows.