Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #108756
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Copy/Destination & Copy/PasteSpecial>Formats SLOW for formats |
| Date | 2016-04-16 01:21 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <neshv4$8cc$1@dont-email.me> (permalink) |
| References | <hcc3hbhl5rj4inot55ebfc2cj63er1p6o4@4ax.com> |
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
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Copy/Destination & Copy/PasteSpecial>Formats SLOW for formats Phrank <pbeal@hotmail.com> - 2016-04-15 23:30 -0400
Re: Copy/Destination & Copy/PasteSpecial>Formats SLOW for formats GS <gs@v.invalid> - 2016-04-16 01:21 -0400
Re: Copy/Destination & Copy/PasteSpecial>Formats SLOW for formats Phrank <pbeal@hotmail.com> - 2016-04-16 09:27 -0400
Re: Copy/Destination & Copy/PasteSpecial>Formats SLOW for formats GS <gs@v.invalid> - 2016-04-16 13:10 -0400
Re: Copy/Destination & Copy/PasteSpecial>Formats SLOW for formats Phrank <pbeal@hotmail.com> - 2016-04-16 13:32 -0400
csiph-web