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

Does this work?

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

--
Charles Chickering

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


"lifeguardernie" wrote:

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

On Jan 1, 4:42*am, Charles Chickering
wrote:
Does this work?

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

--
Charles Chickering

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



"lifeguardernie" wrote:
how can i use the same formula on a whole list without retyping it every row?- Hide quoted text -

- 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

before i read this i tried using fill which worked also

"Joe" wrote:

On Jan 1, 4:42 am, Charles Chickering
wrote:
Does this work?

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

--
Charles Chickering

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



"lifeguardernie" wrote:
how can i use the same formula on a whole list without retyping it every row?- Hide quoted text -

- 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