Advancedfilter criteria range to refer to last row and column

[mergim]

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!

 

[RoryA]

Try:

Workbooks("PEL-BCH.xlsm").Sheets("Sheet2").Range("A1").Currentregion

 

[mergim]

Try:

Workbooks("PEL-BCH.xlsm").Sheets("Sheet2").Range("A1").Currentregion

It helped, thanks a lot !!!