Thread: Macro Help

I really need some help to figure out why I'm getting a runtime error on my macro when I wasn't getting one before. It's a refresh macro to extract data from our accounting software, clear, copy, paste, and combine data onto one combined data sheet.

I'm getting Run-time error 91: Object variable or with block variable not set

My macro is as follows:

Sub REFRESH()
'
' REFRESH Macro
'
    Application.ScreenUpdating = False
'
    Sheets("Actual Transactions").Select
    Selection.ListObject.QueryTable.REFRESH BackgroundQuery:=False
    Sheets("Actuals").Select
    Range("Table_Query_from_ADX_ELEMENTPOWER6[[#Headers],[COMPANY]]").Select
    Selection.ListObject.QueryTable.REFRESH BackgroundQuery:=False
    Sheets("Budget").Select
    Selection.ListObject.QueryTable.REFRESH BackgroundQuery:=False
    Sheets("Combined Data").Select
    Range("A2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Range(Selection, Selection.End(xlToRight)).Select
    Application.CutCopyMode = False
    Selection.ClearContents
    Application.Goto Reference:="Table_Query_from_ADX_ELEMENTPOWER4"
    Selection.Copy
    Sheets("Combined Data").Select
    Range("A2").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("A2").Select
    Selection.End(xlDown).Select
    ActiveCell.Offset(1, 0).Select
    Application.Goto Reference:="Table_Query_from_ADX_ELEMENTPOWER6"
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("Combined Data").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Sheets("ACTUAL DETAIL").Select
    Range("A8").Select
    ActiveSheet.PivotTables("PivotTable1").PivotCache.REFRESH
    Range("A1").Select
    Sheets("ACT VS BUD").Select
    Range("A11").Select
    ActiveSheet.PivotTables("PivotTable1").PivotCache.REFRESH
    Range("A1").Select
    
     Application.ScreenUpdating = False
End Sub

Hello and welcome to the forum - unfortunately you need to read the forum rules, because you've broken rule #1, which says that all threads must have a title descriptive of the problem and not a general request for help. If you edit your thread title to something less generic then I'm sure somebody will be able to sort you out. Thanks.