https://analysistabs.com/excel-vba/finding-last-used-column-with-data-in-particular-row/
Finding last used Column with data in particular Row – Excel VBA Examples