Run and populate a query formula
To create a Macro that runs an existing formula and then populates the results to a target cell, add this method in to your Macro:
Sub ExecuteQueryToCell () QAAMacro.ExecuteQueryToCell "A4", "G14") End Sub
To populate the results to another Worksheet add this method:
Sub ExecuteQueryToCellAnotherWorksheet () QAAMacro.ExecuteQueryToCell "SheetName1!A4", "SheetName2!G14") End Sub