View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scott Scott is offline
external usenet poster
 
Posts: 7
Default If statement to call module based on cell value

Hello-

I have a module that will combine two workbooks, calculate certain
cells, then email the summary information to a group of individuals on
our management team.

Cell D5 is formatted as a percentage and I want to send to a specific
group based on the value of the cell.

I have two modules, SendStats (mid managers), and SendStats1 (mid
managers and upper management) used to determine which
group will be emailed.

If cell D5 is greater than 3%, I want to call module SendStats1,
otherwise I want to call module SendStats.

I tried an IF statement in VBA, but could not get it to work right.
Can someone help?

Thanks-

Scott