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?
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?