>hi everibody,
>
>i want insert a row in a sheet BUT with the formulas ( previous row ).
>
>

>                oRange.entirerow.INSERT && bad because it do'nt copy the formulas
>

>
>which command use ?
>
>bernhart

* do'nt copy the formula
oRange.entirerow.INSERT( 0 , 1 )

BUT copy a range and PASTE copy the formulas !

how can i copy the range ?

thank in advance


bernhart