Hi... I have a worksheet that has this code:
This code runs perfectly in every office versions 2007/10/13. But today i tryed to opens the workbook in a windows 7 ultimate 64 bits and the follwing error came up: "Compile error in hidden module: module1" -> Module 1 is where i have this code.Please Login or Register to view this content.
So i started looking on google for this error and came up with a error from the 64 bit version and the built up version of the workbook. So i checked on google through SystemMetrics32 for 64 bits and in some pages they say that for 64 bits excel versions, the code line had to be replaced for this:
The thing is i dont know how to had this to my previous code and make it in a way that it would work on every version 32/64 bits.Please Login or Register to view this content.
Can anyone help please?
thank you.
Bookmarks