Last seen: May 22, 2025
Changing the colour of a cell does not trigger any events that you can respond to. If you can, you would be far better off using an additional column/...
That's exactly the approach the formula I suggested uses, but without the helper column. If the helper column is OK, it's probably a better option. 🙂
You could try something like: =COUNTA(UNIQUE(FILTER(Table1[Column1],SUBTOTAL(103,OFFSET(Table1[Column11],ROW(Table1[Column1])-MIN(ROW(Table1[C...
Your code checks the last 52 characters to see if they match "xlsm" (which they can't), then the last 50 characters to see if they match "xlsb" (again...
HI Alan, That's odd - I just tried it again and it worked as posted (64bit 365). Would you mind testing this slight alteration? let Source = Ex...
Look at the controls on the form - do any of them look right to you? They all look distorted and they appear much bigger than their properties suggest...
Yes, you can use something like this: let Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], #"Grouped Rows" = Table.Group(Sourc...
It sounds (and looks) to me as though there may be some corruption in your workbook. I'd suggest rebuilding it.
How big is your monitor? Your userform is over 6k pixels wide, which makes it extremely hard to use!
You can add the path in: Name ActiveSheet.Range("C2") & ActiveSheet.Range("C4") As _ ActiveSheet.Range("C2") & ActiveSheet.Range("C6")
You can also use INDEX supplying 0 as the row number argument - for example: =INDEX(I1#,0,3) returns the third column of the spilled array start...
Or use & consistently rather than + for concatenation. 🙂
You can unmerge all the cells in the column at once. If you need to specifically find merged cells, unmerge them and then populate them with the origi...
Set xMItem = xOTApp.CreateItem(0) should be: Set xMItem = xOTApp.CreateItemFromTemplate(mailTemplate) I suspect (hope) Outlook will not ...
Replace your current GETPIVOTDATA(...) section in the relevant formula(s) with IFERROR(GETPIVOTDATA(...),0)