In article , Don Guillett
writes
Still not entirely clear as to your desires. Try this:
Instead of
Range(Cells(2, mc), Cells(lr, mc)).PasteSpecial Paste:=xlPasteAll,
Operation:=x
try
selection.PasteSpecial Paste:=xlPasteAll, Operation:=x


Hi Don

OK that's got it working fine.

It now only operates on the selected cell range , rather than the whole
column , which is perfect.

Thanks again for you time and expertise.



Best Wishes