repeating formulas

[lifeguardernie]

how can i use the same formula on a whole list without retyping it every row?

 

[Charles Chickering]

Does this work?

Sub RowFormula()
Range("A1:A10").Formula = "=Today()"
End Sub

 

[Joe]

Does this work?

Sub RowFormula()
Range("A1:A10").Formula = "=Today()"
End Sub

--
Charles Chickering

"A good example is twice the value of good advice."





- Show quoted text -

On a simpler level, just enter in one cell.
Copy and paste in all cells.
You can use Paste Special also to paste just the formulas...

HTH
Joe

 

[lifeguardernie]

before i read this i tried using fill which worked also