Macro/VBA, Selection.Filldown isn't working.

[heycaryn]

Hello!

I'm trying to automate a report I'm doing, and while running through it I found this bug. When I go to select cell B2, wanting it to fill down, it copies the text from B1 into B2, then does nothing with the remainder of my cells. Any ideas?

Range("C3").Select
Selection.FormulaArray = "=(IF(IF(RC[1]="""",0,1)=0,"""",1))"
Selection.AutoFill Destination:=Range("C3:C942")
Columns("D:D").Select
Selection.Replace What:=" ", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("B2").Select
Selection.FormulaArray = "=MATCH(1,--(R[1]C[1]:R[998]C[1]=""""),0)-1"
ActiveSheet.Range("$A$1:$F$942").AutoFilter Field:=1, Criteria1:= _
"=*Driver Name*", Operator:=xlAnd
Range("B2").Select
Selection.FillDown

 

[mikerickson]

Does the filter hide B2?

 

[heycaryn]

No. The export sheet that we pull from the program essentialy combines two columns, so I filter out the unneeded info before the fill down, because otherwise it would be full of errors.