Range("Source").Copy Range("Target") does exactly that, formatting and
all.

PasteSpecial Paste:=xlPasteFormats must evaluate what to paste and
filter on the formatting for each cell, apart from the cell contents.

Excel also evaluates the length of cell contents since it's limited to
255 characters.

Sounds to me like Excel has more things to deal with when processing
user notes! This should take longer without considering any other
factors that may contribute.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion