Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I edit a formula as part of a macro?
I'm trying to record a macro that will paste stuff from another work sheet,
then update the formulas by adding the items that are in the pasted part to the ones that were already there. Whenever I try to do it the macro stops recording until I get out of the formula. |
#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? |
Reply |
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 |