Automate formula placement in entire column

[Joshua McNichols]

The way I work, I have to repeatedly drag formulas down as I delete rows of data at a time. Sometimes I forget, and this introduces errors into my work. I would like to automate this simple, repetetive process so that every cell in for example Column H (except for a single header row) would include the same formula, all the way down to infinity. So for example, H2 contains the formula =H1+1, H3 contains the formula H2+1, etc. This is not my actual formula, but just an example.

 

[ZAX]

Hey,
It's very simple only three lines of

Sub CopyFormula()
Range("h2").Select
Selection.AutoFill Destination:=Range("h2:h15000"), Type:=xlFillDefault
Range("h1").Select
End Sub

ZAX

 

[Jordan213]

What version are you on? Convert it into a table, the formulas will automatically populate in every row of the table. It also solves the problem of relative cell references, you'll almost never have to use F4 to lock a cell reference again. I convert almost everything into a table, it is much, much easier to work with.

 

[Joshua McNichols]

I'm on Office 2010. Sounds like a good idea!