Forum

Hi Praveen, Looking at the website in my browser, I can see that it periodically sends new information to the browser. I suspect what is happening...

Thanks Miguel, Just a note. If you turn off error handling On Error Resume Next you should turn it back on after the expected error has occu...

Hi Steve, When the timer reaches zero, the value in B1 is zero. If you close the workbook in that condition, you are calling Stoptimer from Workbo...

Hi Steve, You said you found the reason for the debug but it's not clear what that was. You already are calling Starttimer in Workbook_Open and ...

Hi Praveen, The URL in your query responds with HTML not JSON so I get the error in PQ DataSource.Error: The downloaded data is HTML, which isn'...

Hi Bunmi, You can split the column by delimiter (space) from the right, then do it again let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[C...

Hi Tina, It should work fine. Did my formula work for you in the file I attached to my last post? Maybe you need to attach your file where it...

Hi Stephan MID returns a string so you need to use DATEVALUE to convert to a date =DATEVALUE("1/1/"&MID(CELL("filename"), 1+SEARCH("]", CELL...

Hi Tina, My solution requires dynamic arrays which you won't have if you don't have O365. Velouria's formula works for me - see H1 in attached f...

Not at all Stephan, we all learn by doing, reading, Googling etc. I'm always looking stuff up, I can't remember the syntax for everything 🙂 You c...

Hi Tina, An alternative, you could use the new LET function (if you have it) =LET(Unique_ID,UNIQUE(SUBTOTAL(105,OFFSET(F2,ROW(Table1[ID])-M...

Hi Steve, It's very difficult for me to say why it's erroring as I don't have the code or know what preceded the error. But that error is because ...

Hi Stephan, I'm a bit confused about a few things. BG2 is labelled 'Today's date' but you want to populate it with a year? If so you can use ...

In the attached workbook I've added a call to StopTimer like this Private Sub CommandButton1_Click() StopTimer ActiveWorkbook.Save ActiveWorkbook.C...

Hi Steve, You need to call StopTimer before you close the workbook. Application.OnTime is set at the application level i.e. the Excel program it...