Filling formula using macro

[prasoon_pcube]

My excel file is having 2 worksheets.
Sheet 1: is blank
Sheet 2: first 3 columns of the first row is having formula.
I will paste few rows in the first sheet. Can i have a macro, which
fills all the coresponding rows in the second sheet with corresponding
formula in the first row.
Thanks.
Prasoon.

 

[Earl Kiosterud]

Prasoon,

Range("A1:C1").Copy Destination:=Range("A2:C5")
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...