Hello,
Good day Mr. Excel users!
Above code works fine.
When I add Sheets("forBacklog").Activate, it doesn't work. But if I run below code, it works just fine.
Sheet10 is the same as Sheets("forBacklog").Activate
The code is stable for months suddenly this error comes up, but when I use the previous Excel file, it works perfectly fine. Oh yeah, I can just use the old file as a workaround but the data in the file isn't updated anymore so it makes sense as much as possible to use the latest file.
The error message is:
Run-time error '-2147319767 (80028029)
Automation error
Invalid forward reference, or reference uncompiled type.
Hope someone is having a good day and help me and my team.
Cheers!
Good day Mr. Excel users!
Code:
Sheets("OB Raw").ActivateAbove code works fine.
Code:
Sheets("OB Raw").Activate
Sheets("forBacklog").ActivateWhen I add Sheets("forBacklog").Activate, it doesn't work. But if I run below code, it works just fine.
Code:
Sheets("OB Raw").Activate
Sheets10.SelectSheet10 is the same as Sheets("forBacklog").Activate
The code is stable for months suddenly this error comes up, but when I use the previous Excel file, it works perfectly fine. Oh yeah, I can just use the old file as a workaround but the data in the file isn't updated anymore so it makes sense as much as possible to use the latest file.
The error message is:
Run-time error '-2147319767 (80028029)
Automation error
Invalid forward reference, or reference uncompiled type.
Hope someone is having a good day and help me and my team.
Cheers!
Last edited:
