Hi,
When I insert a row I would like the formula from the row below to be
automatically copied upwards.
Many Thanks
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks