Copy/Destination & Copy/PasteSpecialFormats SLOW for formats
Ok. I'm on my home computer at the moment, so I'll get that uploaded
in a little while. I appreciate the help, especially since about two
dozen people in my office use what I've made. Thanks!
Frank
On Sat, 16 Apr 2016 13:10:30 -0400, GS wrote:
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.
I suspect your workbook has become corrupt! Best to upload as Claus
suggests so we can have a look at it...
|