I would like a function similar to below, but for the
first empty column within row 36.

Below is what I use for the first empty row.

last_row = wks_Stock.Cells(Rows.Count, 1).End(xlUp).Row


Thanks,

Simon