Hi
copy the source cell and paste it with 'Edit - Paste Special - Values'

--
Regards
Frank Kabel
Frankfurt, Germany

RCbear wrote:
Sheet has complicated formating with lines and fills. Need to lokc
formating but be able to drag cell values without the formating
smearing over.
Can't figure it out by myself :-(