excelnut1954 wrote:

Is there a way to keep it on the same line, but move it to column B ?


Hi excelnut1954

Try

Cells(ActiveCell.Row,"B").Select

Regards

Steve

Thanks,
Hope everyone had a great holiday
J.O.

It ain't a holiday in the UK. :-(