AutoFilter in External Workbook?
Set wbBookdata = Workbooks.Open(fPath & datafile, False, True)
wbBookData.Activate
With wbBookData.sheets(dSheet)
.AutofilterMode = False
set rng = .Cells(8,27).currentRegion
fld = 27 - rng(1).column + 1
rng.Autofilter Field:=fld, Criteria:="=1"
rng.Copy thisworkbook.Worksheets( _
strName).Range("A1")
.AutofilterMode = False
end With
thisWorkbook.Activate
--
Regards,
Tom Ogilvy
"DISMfish" wrote:
Switched the col/rows. Autofilter is still not working?
ActiveWindow.Cells(8, 27).AutoFilter Field:=27, Criteria1:="=1"
|