LinkBack URL
About LinkBacks
this code counts the number of "no call" in column 5 how can i get it to count "no call" and "no calls" in column 5.
ActiveCell.FormulaR1C1 = "=COUNTIF(CallData!C5,""NO CALL"")"
slight tweek needed
this code counts the number of "no call" in column 5 how can i get it to count "no call" and "no calls" in column 5.ActiveCell.FormulaR1C1 = "=COUNTIF(CallData!C5,""NO CALL"")"
Hi,Originally Posted by khalid79m
this code counts the number of "no call" in column 5 how can i get it to count "no call" and "no calls" in column 5.ActiveCell.FormulaR1C1 = "=COUNTIF(CallData!C5,""NO CALL"")"
try
note, I have avoided using "NO CALL*"ActiveCell.FormulaR1C1 = "=COUNTIF(CallData!C5,""NO CALL"")+COUNTIF(CallData!C5,""NO CALLS"")"
hth
---
Si fractum non sit, noli id reficere.
Sorry it doesnt work
i need it to count both no call and no calls
and give a total
Then try as Activecell.Formula = "=COUNTIF(CallData!E:E,""NO CALL"")+COUNTIF(CallData!E:E,""NO CALLS"")"
which works for me, I took it that your previous formula had worked.
---
Last edited by Bryan Hessey; 04-04-2007 at 08:29 AM.
how do i get a script to run if
in cell C2 it says "TL" or "Team Leader"
eg if C2 = "TL" or "Team Leader" then run "Macro1" if c2 = "IBC" then run "Macro2" , if C2 = "CSR" or "SMM" then run "Macro3"
and so on..
thanks it works , my scipting was wrong
good to see it work, and thanks for the response.
---
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks