VBA Copy Then Paste Speed ?

[Pinaceous]

Hi All,

I'm using Excel 2013 and I would like to copy a large area Table area on Sheet1 being, Table5[[Column2]:[Column20]] of area $B$10:$T$211, to Sheet 5!$C$2:$V$201 special paste 'text'.

I can of course 'record a macro' which is fine, but is there anyway to speed up this process more efficiently by use of a written code verse a scripted code? Right now it takes about 30 seconds to long and would like to reduce this time factor as much as possible.

Can you be of assistance?

-Pinaceous

 

[Pinaceous]

Hi Mark,

Yeah your right, let me 'test' the code out that you provided on my two situations and I'll write back to you and let you know.

Thanks again.

R/
-Pin

 

[Pinaceous]

mole,

I just realized your text was a link and I really like that one about the screen not flickering.

Thanks.

R/
-Pin

 

[mole999]

its the fastest I know, I was wondering if you had read it

 

[Pinaceous]

Mole!

That is the ticket!

Many Thanks,

-Pin

 

[Pinaceous]

Thanks Mark!

I got it!

 

[Pinaceous]

Hi rockon0921,

I really like your code. I just noticed that at the bottom left of Excel 2013 it displays, "Select destination and press ENTER or choose Paste". (After the macro is executed.)

Do you know how I can get rid of this notice in assigning a destination or in getting around this "Excel provided option"?

Thanks,

-Pin

 

[GTO]

Thanks Mark!

I got it!

Cool!