Auto Fill macro

[Alvaroro84]

Selection.AutoFill Destination:=Sheets("Sheet1").Range("E2:E" & LastRow).SpecialCells(xlCellTypeVisible), Type:=xlFillDefault

I try to use this to code to auto fill all visible cells in column E. The reason it has to be visible rows is because it runs a filter before the code. However, the code above seem to be wrong can some one help me fix the above code in a similar format if possible

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.

 

[Alvaroro84]

Thanks for letting us know. Glad we could help.

Thank you for all the help!