Alvaroro84
Board Regular
- Joined
- May 13, 2022
- Messages
- 65
- Office Version
- 2016
- Platform
- Windows
VBA Code:
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