Forum

No worries 🙂

You're welcome Salim.

Hi Audrian, Use F8 to step through the code. You can see exactly what is happening then, check your variables and objects etc. Please read those ...

Hi Audrian, No need to click on the Quote icon when replying, it just adds clutter to the thread and will be deleted 🙂 Please just click on the 'A...

Hi Audrian, That would indicate that something is wrong with HTMLTable.Rows.Length. Which could mean that there isn't a table stored in HTMLTable....

Hi Daniel, and when you step through the code, what value does fileLoc & fileStr have? Does fileLoc exist and is fileStr a valid filename? ...

No worries, you can always create a dummy file with just a few examples of the data. Thanks for letting us know you got it figured out. Regards ...

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...