View Single Post
 
Old 03-03-2024, 03:16 AM
Italophile Italophile is offline Windows 11 Office 2021
Expert
 
Join Date: Mar 2022
Posts: 542
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default

Timing issues are common when VBA code invokes functions that are not under the control of the host application, especially if those functions are called repeatedly in a loop.

Copy and Paste are functions of the OS. As VBA can execute more quickly than data can be transferred to, and, especially, from, the clipboard it is necessary to use DoEvents, as Andrew suggested.

If the code calls another application, a delay timer may be necessary.
Reply With Quote