| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using code to edit spreadsheet formulas
I need to edit formulas in about 10,000 cells. The formulas are all
basically the same: they differ only in that two cell references in each formula are unique to that cell. The basic format of each formula is '=Function1(CellRef1,CellRef2,"")', where Function1 is a User Defined Function. Also, the edits I need to make are simplistic: I need to change each 'Function1' to 'Function2', where Function2 is also a User Defined Function. Is there a way to use XCL 2003 or XCL 2010 Code to do my edits? TIA, JingleRock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Some more help to edit some formulas | Excel Worksheet Functions | |||
| how do I edit an embedded spreadsheet? | Excel Worksheet Functions | |||
| Trying to edit a spreadsheet | Excel Discussion (Misc queries) | |||
| Trying to edit a spreadsheet | Excel Discussion (Misc queries) | |||
| How can I edit in the spreadsheet viewer? | Excel Worksheet Functions | |||
![JingleRock[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
