Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert a row in excel
Message
From
10/06/2010 08:34:40
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Miscellaneous
Thread ID:
01468252
Message ID:
01468278
Views:
52
This message has been marked as a message which has helped to the initial question of the thread.
>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

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)
Previous
Reply
Map
View

Click here to load this message in the networking platform