Macro 32bit vs 64 bit

[Alex1234567]

Hello. I'm unable to use a macro in a 64 bit version of excel that works in the 32 bit version of Excel. MS's documentation says the following. Can someone provide the known declarations that need to be changed or point me to documentation that say which declaration statements need to be changed?

"In VBA 7, you must update existing Windows API statements (Declare statements) to work with the 64-bit version. Additionally, you must update address pointers and display window handles in user-defined types that are used by these statements. This is discussed in more detail in this article as well as compatibility issues between the 32-bit and 64-bit versions and suggested solutions."

Any help is appreciated.

 

[Alex1234567]

FYI, the declarations made in my macro are...

Dim TrxRows As Range, xCell As Range, dCell As Range
Dim ShtVis As Integer

 

[Alex1234567]

Sorry for the multiple replies. Here is most of the code. I removed some sections that I don't believe are contributing to the issue but I can/will post the whole thing if needed.

Sub UpdateData()


    Sheet2.Activate
    If Range("A1048576").End(xlUp).Row = 2 Then Exit Sub
    
    Application.ScreenUpdating = False
    Dim TrxRows As Range, xCell As Range, dCell As Range
    Dim ShtVis As Integer
    
xxxxx other code xxxxx
    
    Call Placeholders
    
xxxxx other code xxxxx
    
    ActiveWorkbook.Names.Item("PivotSource").RefersTo = Range("A1:Z" & Cells.Find(What:="*", After:=Range("A1"), LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row)
    ActiveWorkbook.RefreshAll
    Cells.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Activate
    Range("A1").Activate
    Application.Goto Sheet1.Range("A1"), Scroll:=True
    Sheet3.Visible = ShtVis
        
    Application.ScreenUpdating = True


End Sub

 

[Kenneth Hobson]

You did not post any API code.

See these links for bit version specific code and tips.

https://support.microsoft.com/en-us...lp-files-win32api-ptrsafe-with-64-bit-support
http://www.jkp-ads.com/articles/apideclarations.asp