Using paste in my VBA code depends on how much I am pasting. If the amount of text you are pasting is relatively small, this approach works well and does not apply the normal formatting. However, when I paste a large amount of text, the answer seems to be yes. Seems this approach works to protect against crashing the system with too much formatting.
Best always
|