MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Auto Fill

Posted by David on September 19, 2000 2:24 AM

Can you do autofill without changing the font color?
some are red some are blue and some are black and I want the formulas to austo fill but the font color not to change.

temp = Worksheets("List").Range("A3").End(xlDown).Row

Worksheets("List").Range("I3").AutoFill Destination:=Worksheets("List").Range("I3:I" & temp), Type:=xlFillDefault

Posted by AB on September 19, 0100 7:03 AM

If you only want to add formulas, don't use autofill.

Intersect(ActiveCell.CurrentRegion, ActiveCell.EntireColumn).FormulaR1C1 = ActiveCell.FormulaR1C1

Where the active cell can be assumed to be [I3] in your case.