Help with Named Ranges in VBA

[ManUBlueJay]

I have been using Named Ranges in VBA for years, but recently it gives me a runtime error when there is a formula in a named range.
If I put the formula Sum (b1:c1) in A1 and refer MyRange to A1 it works fine in VBA. However when I put the formula Sum (b1:c1) directly in to MyRange I get a run time error in VBA yet I can call MyRange in Excel and it will function correctly.

 

[ManUBlueJay]

After digging deeper it says it is missing MSCOMCT2.ocx. This file used to have the MSDatepicker which is no longer available for 64 bit office.
I rengerated the file in Windows 7 and everyting works perfectly. I removed the Datepicker and the code alluding to it. WHat else must I remove so the file can be opened in Windows 10 64 bit operating system without it looking for this file

 

[Norie]

Open the file in Windows 10, remove the reference to MSCOMCT2.ocx under Tools>References..., save the file and then you should be fine.