Hello.
I have been trying to google around for a solution for my problem but without any luck.
Reacently we had an upgrade on our office package at my work. We went from Office 2010 to Office 2016. What seems to happen is that some of my macro functions wont work anymore, for example I have a button that will sort chart data in ascending order and after the update it wont work.
If I go into debug mode and pushes F8 to see whats wrong, it gives me "Run-time error 1004: Sort method of Range class failed"
The coursor stops at DataOption1:=xlSortNormal. But it worked like a charm before the update to 2016...
Also is I compile the project it tells me that another function aint defined (or something similar)
Whole Excel seems slow and I have also observed that Application.screenupdate and .calculation aint working no more either.
I run Office 2016 x86 on Windows 7 64-bit.
I have checked trustcentrer and active x-settings. I have also looked into Tools/References... There is no references missing..
So I am totaly blanked right now, and I have like 7 documents thats has macrofunctions that wont work/run.
I really wish someone can help me.
I have been trying to google around for a solution for my problem but without any luck.
Reacently we had an upgrade on our office package at my work. We went from Office 2010 to Office 2016. What seems to happen is that some of my macro functions wont work anymore, for example I have a button that will sort chart data in ascending order and after the update it wont work.
If I go into debug mode and pushes F8 to see whats wrong, it gives me "Run-time error 1004: Sort method of Range class failed"
The coursor stops at DataOption1:=xlSortNormal. But it worked like a charm before the update to 2016...
Also is I compile the project it tells me that another function aint defined (or something similar)
Whole Excel seems slow and I have also observed that Application.screenupdate and .calculation aint working no more either.
I run Office 2016 x86 on Windows 7 64-bit.
I have checked trustcentrer and active x-settings. I have also looked into Tools/References... There is no references missing..
So I am totaly blanked right now, and I have like 7 documents thats has macrofunctions that wont work/run.
I really wish someone can help me.