Kurt Smart
Did You read my previous (#24) Reply; from the 1st to the last line?
Ex You asked to 'copy&paste&clear-pasted-away' some ranges ... it do so!
That's move! If 'copy&paste' then there were two times same data!
Now, I changed that it 'copy' and 'paste only values' .. it's different!
... and if previous happen then it clears 'copy range' as You wanted.
... clear means 'clear' = all-away = delete that range!
... and You missed, in the beginning, one point too - You're using a table!
> What would someone do with Your the newest file?
I uploaded my 'paste special'-version.
Did You read my previous (#24) Reply; from the 1st to the last line?
Ex You asked to 'copy&paste&clear-pasted-away' some ranges ... it do so!
That's move! If 'copy&paste' then there were two times same data!
Now, I changed that it 'copy' and 'paste only values' .. it's different!
... and if previous happen then it clears 'copy range' as You wanted.
... clear means 'clear' = all-away = delete that range!
... and You missed, in the beginning, one point too - You're using a table!
> What would someone do with Your the newest file?
I uploaded my 'paste special'-version.