Is there a VBA PasteSpecial(PasteAllExceptFormats) ?
Sorry... there is nothing in a single line. You are probably bet with a
regular paste and then put back the colours...
--
HTH...
Jim Thomlinson
"Richard Buttrey" wrote:
I'd like to be able to copy a column which includes formulae, values
and cell background colour formatting, and paste it to another column
which has different colour backgrounds.
I need to keep the formulae from the copied column and the formatting
for the object column.
I realise I can do a PasteAll, and then reset the original colours
with another line or two of code, but a single operation would be
preferable.
Any suggestions please?
Usual TIA
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
|