EXCELLENT. So simple, yet effective. I appreciate your quick response.
Thanks.
Opps... sorry about the holiday reference. I guess it's my American
"Me" syndrome at work. Being of Welsh descent, I've always favored
those in the UK.
Thanks again,
J.O.

Scoops wrote:
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. :-(