How do I edit a formula as part of a macro?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel 2007: Help creating a macro that will run Solver? 3
Copying parts of a sheet with macro 7
Use macro to write formula 1
Macro to extend formulas 4
Macro to edit formula in cell 3
Macro to copy value in field and insert it into filter 2
VLOOKUP anchored cell reference changing when macro runs 2

Back
Top