How to run a macro based on an If formula?

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

Guest

I am trying to create a macro that is linked to both a formula and 2 other
macros. An example is one macro will raise a number and the other one will
lower it. I'm trying to create a macro that will automate this process and
tie it into an IF formula. Like =If(H<.3,I want to stop, use macro 2). I'm
new to macros but I created ones to raise and lower this number now I just
want to automate the raising and lowering to some set acceptable degree of
error.
 
It sounds like you are trying to solve a problem by trying incremental
solutions.

You might want to look at the built in capability of Goalseek or the more
sophisticated Solver under the tools menu.
 
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

Run Macro If Cell have "x" value 0
Running macro operations in serial fashion 6
Run Macro on All Sheets Q 8
Macro Formula 0
Macro 2 insert formula if part of cell contains specific text 5
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
calling a macro within an excel formula 2
MACRO THAT BUILDS ON ANOTHER MACRO'S DATA 6

Back
Top