VBA Copy from Closed Workbook

MikoSDS

New Member
Joined
Feb 22, 2019
Messages
24
Hello Everyone,

I have a small problem with copying sheets from closed workbook "x" to my workbook "y". So the copying isn't the problem, just the formulas in workbook "x" because in this workbook I have formulash which referres to another sheet in this workbook. So when I am coping this sheet and with Application.Screenupdating = False, the formulas returns #VALUE , but if I do the same thing just with Application.Screenupdating = True it works perfeclly. Seems like the screenupdating is causing the problem, is there any way to do this with Application.Screenupdating = False and the formulas will return correct numbers?

Thank you in advance!
 

MikoSDS

New Member
Joined
Feb 22, 2019
Messages
24
My fault, the problem was caused by Calculation Manual, should be automatic, not the screenupdating.
 

Forum statistics

Threads
1,082,587
Messages
5,366,486
Members
400,894
Latest member
frog9000

Some videos you may like

This Week's Hot Topics

Top