vba advancedfilter, flexible criteria

[Ghostbuster_one]

hi all
i am wondering how i can make the criteria in my advance filter flexible. I now have data added up to row D5, but it might as well be only row D4 or D1 and D2.
How can i get it to read lines that are populated ?
Many thanks!
Ralph

Sub ADV()
'
' ADV Macro
'

'i am in file 2

Cells.Advancedfilter Action:=xlFilterInPlace, CriteriaRange:=Workbooks( _
"File 1.xlsm"). _
Sheets("List of Acc. - Resp.").Range("A1:AD5"), Unique:=False
Windows( _
"File1.xlsm"). _
Activate
End Sub

 

[Ghostbuster_one]

The scope of your variables is wrong. A little light reading: Understanding Scope

Did the trick Rory, thanks a lot !