Thread: PasteSpecial takes too long
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ramil[_2_] Ramil[_2_] is offline
external usenet poster
  
Posts: 4
Default PasteSpecial takes too long
Hi all,
Why does it take so long to execute a PasteSpecial Paste:=6 -- xlDataValidation -- in code (34 secs copying from 616 rows, 1 column and pasting to 616 rows, 4 cols) while from Excel, it takes next to no time at all.
Reply With QuoteReply With Quote