Forum Discussion
VBA: runtime error 1004 : Method range of object - 'Global' failed
Hello everyone, I have this error in my code (red part). I guess it´s a just a little mistake, but I can´t find it. Maybe someone can help me. It is made on CommandButton for sort by two keys and...
I am getting same error in my below code. Can someone help on priority??
Sub Extract_Output()
Windows("Mailer - 05-06-21.xlsm").Activate
Sheets("Sheet2").Select
Range("A1").Select
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
'Option Explicit
Dim cell As Range
Dim Table As Range
Dim cutpath As String
cutpath = ActiveWorkbook.path & "\"
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each cell In Range("RM")
[valRM] = cell.Value
Range("a1:ah20000").AdvancedFilter Action:=xlFilterCopy, criteriarange:=Range("Criteria"), CopyToRange:=Range("Extract"), Unique:=False
Range(Range("Extract"), Range("Extract").End(xlDown)).Copy
Workbooks.Add