In article , Don Guillett
writes

Select for the copy or the destination?

Hi Don

Thanks for getting back again. I hope I understand your question
correctly.

I'd like to be able to highlight a group of cells in the same column ,
and have the macro apply only to the selected cells , rather than the
whole column , if possible.

The macro could simply overwrite the highlighted cells with the new
value , please.



Best Wishes