Last seen: Jun 8, 2026
Hi Daniel, That code works fine for me on my W10 PC. At what line does it debug on the Mac? Have you stepped through the code to see where it e...
Hi Salim, You can use an IF statement - see attached. In C20 you have =IF(D19>0,D19,"") and in E20 you have =IF(D19<0,D19,"") ...
Hi Adam, The only reason I can think that you would have this problem if you are calling ThisWorkbook.RefreshPT is if the code in the Worksheet_Dea...
Hi Ristee, Please read this Always supply a workbook so we can refer to the data you are talking about. Excel stores dates and times as ser...
Hi Audrian, You had 2 Subs, one for logging in and one for getting the table. But when the Login sub finished, the GetTable module had no way to g...
Hi Ali, Please see the attached workbook. It uses the COUNTIFCOLOUR function and takes 2 arguments. The 1st is the cell that has the colour you w...
Hi Mohith, Try this. You can add whatever fields you want to the Body cell, but you can leave out the time as the code adds this. Regards Ph...
Hi Amir, If you need to interact with the page then you should consider using Selenium to drive your browser That said, that site looks like i...
Hi Mohith, You asked for the email to be sent when the body of the message is entered in Col H and that is what the code does. But it''s easy to m...
Hi HSAR, You haven't supplied a workbook. That VBA code isn't valid so it can't be giving an accurate result. Did you try the code I linked t...
Hi HSAR, Please supply workbooks when you are referring to data and it will be useful for those helping you. Otherwise we have to type everything ...
Hi Tori, If you can use a formula you should use it. I'd only use VBA when a formula can't do what I need. In this case you can get the data fr...
Hi Mohith, Please see attached file. When the message body is changed on a particular row, and email is sent to the email address on that row. ...
you're welcome
Hi Mohith, Yes this can be done, though I'd caution against triggering an email when the Body of the message in Col H is entered. What if you make...