https://quadexcel.com/wp/find-the-last-row-column-or-cell-in-excel-vba-with-the-range-end-method-part-1-of-3/
Find the Last Row, Column, or Cell in Excel VBA with the Range.End Method (Part 1 of 3)