One way:

Replace your entire code with

Log.Cells(QuoteRow, Columns.Count).End(xlToLeft)(1, 2).Value = Dt

In article
,
jlclyde wrote:

I was trying to find the last column in a row that has information in
it and then putting my information in the next column. Any thoughts?