Hi,
I am doing an advanced filtering, and i want to change my criteria range so it refers to last row and column. E.g
Range("A1:E30000").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Workbooks("PEL-BCH.xlsm").Sheets("Sheet2").Range("A1:B40"), Unique:=False
My criteria range is refering to another document's "A1:B40". i want to refer to its last row and column.
Thanks!
I am doing an advanced filtering, and i want to change my criteria range so it refers to last row and column. E.g
Range("A1:E30000").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Workbooks("PEL-BCH.xlsm").Sheets("Sheet2").Range("A1:B40"), Unique:=False
My criteria range is refering to another document's "A1:B40". i want to refer to its last row and column.
Thanks!