Automatically copying rows
 

Hi,

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

Many Thank

--
T De Villier
-----------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...fo&userid=2647
View this thread: http://www.excelforum.com/showthread.php?threadid=55879

Automatically copying rows
 

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