Automatically copying rows

Hi,

When I insert a row I would like the formula from the row below to be
automatically copied upwards.

Many Thanks

To do it manually, hightlight the entire row and press Ctrl-C (Copy) or
right-click and select "Copy". Then right click the same row and select
"Insert Copied Cells".

in VB do: (example to copy row 2)

Range("2:2").Select
Selection.Copy
Selection.Insert shift:=xlDown
Application.CutCopyMode = False


"T De Villiers" wrote:

>
> Hi,
>
> When I insert a row I would like the formula from the row below to be
> automatically copied upwards.
>
> Many Thanks
>
>
> --
> T De Villiers
> ------------------------------------------------------------------------
> T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
> View this thread: http://www.excelforum.com/showthread...hreadid=558798
>
>