View Single Post
  #1   Report Post  
SATB
 
Posts: n/a
Default Macro and If Statement

Here's the situation: I have a worksheet that will have an "X" in
either cell F3 or G3 or H3. What I would like to do (via a macro), is
to examine F3, G3 and H3, and if there is an "X" in anyone of those
cells, to run another specific macro.

For example:

Run a macro (for example called "totalsummary")to determine...

If there is an "X" in F3, then run a macro called "summaryEL";
If there is an "X" in G3, then run a macro called "summaryHT";
If there is an "X" in H3, then run a macro called "summaryFA".

This has to be a macro that starts this process, rather than an if
statement, as I wish to control when this process will happen seperate
from the condition.

In other words, the macro that I run will have if statements imbedded,
and if anyone one of those if statements are true (as it will be only
one), the result is antoher seperate macro running.

Is this a long way of doing this, or is there a better way.

Thanks in advance.

Pete