>hi everibody,
>
>i want insert a row in a sheet BUT with the formulas ( previous row ).
>
>
> oRange.entirerow.INSERT
>
>
>which command use ?
>
>bernhart
I don't know whether Excel has an option to insert a row, maintaining formulas. As far as I know, you have to insert the empty row, and then use copy-and-paste.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)