![]() |
How to Copy excel formulas from one excel to other
Can anybody suggest me how to copy excel formulas from a range and paste it to another excel programatically using c#. Any suggestionwill be appreciative.
|
How to Copy excel formulas from one excel to other
|
How to Copy excel formulas from one excel to other
Syam has brought this to us :
Can anybody suggest me how to copy excel formulas from a range and paste it to another excel programatically using c#. Any suggestionwill be appreciative. Try... { oXLApp.Range("TargetAddressGoesHere") = oXLApp.Range("SourceAddressGoesHere"); } -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
How to Copy excel formulas from one excel to other
Corrected to reflect copying formulas instead of values...
Try... { oXLApp.Range("TargetAddressGoesHere").Formula = oXLApp.Range("SourceAddressGoesHere").Formula; } -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
How to Copy excel formulas from one excel to other
Oops.., syntax error correction...
Corrected to reflect copying formulas instead of values... Try... { oXLApp.Range("TargetAddressGoesHere").Formula == oXLApp.Range("SourceAddressGoesHere").Formula; } -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
All times are GMT +1. The time now is 10:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com