| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
You've reached the threshold that separates recording macros and
writing code from scratch. From here, to update a formula in a cell, you'll have to know how to parse strings of text- basically taking the formula apart letter by letter, and replacing old elements with new. Can you give an example of the old formula, and what has to be updated? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
| Macro Formula revision? | Excel Worksheet Functions | |||
| Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
| Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
Threaded Mode
