PDA

View Full Version : Problem with filtering a list



prabhafriend
10-15-2010, 12:34 AM
Why this is working?
ActiveWorkbook.ActiveSheet.ListObjects("LaserList").Range.AutoFilter Field:=3, Criteria1:=cell.Value

but not this:

Workbooks("320_033110_Doral_Working").Sheets("Laser").ListObjects("LaserList").Range.AutoFilter Field:=3, criteria:=cell.Value

Is implicit and Explicit referencing matters?

mdmackillop
10-21-2010, 02:22 PM
Can you post a workbook demonstrating the problem.

Tinbendr
10-21-2010, 05:32 PM
You're missing the extension.

Workbooks("320_033110_Doral_Working.XLS")......