Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108765

Re: Copy/Destination & Copy/PasteSpecial>Formats SLOW for formats

Show all headers | View raw

> 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 <gs@v.invalid> 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...

-- 
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

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