Forum

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

Hi Bill, you need to modify the declarations and data types as described in this article Private Declare PtrSafe Function SHBrowseForFolder ...

Hi Riste, Times and dates are stored as 'serial' numbers in excel so if your time is in A1 you can use =IF(AND(A1>0,A1<0.25),1,0) This ...

Hi Stefan, If you leave the week number column in the source data table you can use a pivot table to summarise the data as you wish. There are som...

Hi Maurizio, Thanks for letting us know. Regards Phil

Hi Luna, If you provided your workbooks it'd be easier to see what is going on. We also don't know how the source file and table are generated/mod...

Hi Mido, I've created a new sheet and a table on that sheet to keep track of what emails have been sent. The records will show the person's name...

Hi Wansley, Please see attached. Do you want to be able to turn off highlighting on a per sheet basis or for the whole workbook at certain times...