Interesting. And your first sentence below about Range("Source").Copy
Range("Target") is what I use now (and I think I got that from you a
little while back). I tried the PasteSpecial PasteFormats because I
was having this issue with the first option.

As for the User Notes, no one ever enters more than 255 characters -
these are simple quick reminder notes; the longer they are the harder
it is to quickly see and absorb the info.

Here's a possible consideration, though. When this pastes formats,
it's also pasting the conditional formatting from the main QueryBuster
page. I'm not sure that's the issue, though, because it's doing the
same for the other columns that it's copy/pasting in, and there's no
delay there. It seems it's something just with the User Notes column
E.

As for conditional formats, I don't really want or need that at this
point in the macro, as the conditional formating gets added at the
end. Is there a way to copy/paste just the color highlighting?

I'm going to try two things:
1) I'm going to delete column E and reinsert a column - maybe there's
something in column E that is causing the delay
-- Although I've just tried to do that, and it's taking a VERY long
time to delete the column (ref my post in the Excel.Misc group). I
think all of these issues are tied to gether, possibly at a workbook
level, because these are different sheets, both with the same LONG
delay to do a simple task.

2) Recreate the workbook. Not what I want to do, but I'm not sure how
else to fix this.

Any thoughts? Thanks!

Frank


On Sat, 16 Apr 2016 01:21:42 -0400, GS wrote:

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.