troubleshooting Question

Add New Condition

Avatar of Billa7
Billa7 asked on
Microsoft Excel
9 Comments1 Solution290 ViewsLast Modified:
How to add another if condition in this script:  

Need to add "Search*"

If WS.Cells(i, 4) = "Recall" Then
                                    WSt.Cells(FindTime.Row, DateFoundCol).Interior.ColorIndex = 27
                                    'Compute Time from and To
                                    mTime1 = WS.Cells(i, 2) - mCTime1
                                    mTime2 = WS.Cells(i, 2) + mCTime2
                                    
                                    WSt.Cells(FindTime.Row, DateFoundCol) = WSt.Cells(FindTime.Row, DateFoundCol) & " [Sum Total]" & _
                                                 "(" & Format(mTime1, "hh:mm") & "-" & Format(mTime2, "hh:mm") & ")"
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros