overuse of the sentence ".Select" to perform various functions makes my program is slow

Greetings all,

I am conducting a financial program in VBA to estimate changes in securities, however overuse of the sentence. "Select" to perform various functions makes my program is slow. An example of this is the routine I use to copy the titles from one sheet to another.

Please Login or Register  to view this content.

This code works but if I have to copy the program 5,000 titles takes around 40 minutes to run. Please tell me how else I can write the code for me to select a specific cell and copy and paste the value or perform the various actions that need.

Excuse my translation errors. My English is very bad

Can you describe VERBALLY what the macro is doing? I'm almost following it all, but want to confirm.