Attempting to Selection.Filldown

[schnabs]

Hello,
I am trying to use the Macro recorder to get some coding going. I need to set several filters, then autofill column A. When I use the recorder, I get
Range("A1").Select
ActiveCell.FormulaR1C1 = "Total"
Range("A1").Select
Selection.FillDown
I know from prior excel VBA coding that were the filter not on, the Selection.Filldown would be Selection.Autofill = Range(blahblah).
I was wondering if there was a way to use the autofill, or filldown, without overwriting the filtered out cells.
Thanks in advance!

 

[SkipVought]

Hi,

Try this, assuming that your filtered table is ISOLATED from all other data on the sheet...

    With [b1].CurrentRegion
        [a1] = "Total"
        Range([a1], Cells(.Rows.Count, "A")).FillDown
    End With

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[schnabs]

Thanks Skip, I'll give it a try. The solution I found myself, while sort of messy, is selecting all visible cells in Column A, then put Total in the formula bar and press CTRL Enter.