You need to use “PtrSafe” when declaring function :
Private Declare PtrSafe Function
Also in 64bit Excel, use LongLong instead of Long
1
solved Converting Excel VBA 32bit code to 64bit
You need to use “PtrSafe” when declaring function :
Private Declare PtrSafe Function
Also in 64bit Excel, use LongLong instead of Long
1
solved Converting Excel VBA 32bit code to 64bit