• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

VBA for Excel question

Y

Yossarian

Lifer
One workbook, two worksheets in it. User is in worksheet 1 and activates a function that pastes data into worksheet 2. How can I do this without making worksheet 2 active? I can't get paste to work unless I activate the worksheet I'm pasting to. I want to prevent worksheet 2 from appearing briefly during the operation.
 
Put this line at the beginning of your macro:

Application.ScreenUpdating = False

This will prevent your change to the other sheet from being seen. Just switch back to the original sheet at the end of the macro and make sure you set ScreenUpdating to True.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top