Suppose there is one column that has blank data after filtering a table. How do I use VBA to fill these blank columns with a formula using filldown? The formula is on one of the cells in that same column. I tried the code below and it fills down way below the last visible row and it also copied formatting which I did not want, such as strike through, etc.
VBA Code:
With Database.UsedRange
.Resize(.Rows.count - 1).Offset(1).Columns("H"). _
SpecialCells(xlCellTypeVisible).FillDown
End With