I'm doing a large copy/paste macro from an input form into a data table. I'm still designing both, so I'd like to use a named column in my data table rather than a set column letter.
how can I update the "F" in this so it uses a named column like lastCol instead?
how can I update the "F" in this so it uses a named column like lastCol instead?
VBA Code:
With dataWks
nextRow = .Cells(.Rows.Count, "A").End(xlUp).Offset(1, 0).Row
End With
dataWks.Cells(nextRow, "F").Value = inputWks.Range("lastIn").Value