Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using an if then statement call a caption box to a cell | Excel Programming | |||
using an if then statement call a caption box to a cell | Excel Programming | |||
using an if then statement call a caption box to a cell | Excel Programming | |||
Call a macro or sub based on the name of a cell? | Excel Programming | |||
Call a macro or sub based on the name of a cell? | Excel Programming |