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