Last seen: Jun 10, 2026
You can define a named range, WeeklyDPMO as: =Sheet1!$J$9:INDEX(Sheet1!$J$9:$J$13,COUNT(Sheet1!$J$9:$J$13)) (adjust to match your real work...
Can you clarify the "when I graph all the data" comment? Charts will only generally ignore blank cells (no cell that contains a formula is truly blank...
Set OutMail = OutApp.CreateItemFromTemplate(sheet1.range("E25").value) should do it.
You should be able to use #,##0.00(E) or #,##0.00("E")
Really? It was the first hit for me using those search terms:
Have you checked any conditional formatting formulas, data validation, charts, table formulas etc? Bill Manville’s FindLink add-in is very useful for ...
If your XLOOKUP is finding a match but the cell in the result column is blank, it will return 0. If you can't see the 0, then either the cell format o...
Yes, but a screenshot doesn't really help if the display is suppressed. 😉 If you alter the XLOOKUP to remove the 'if not found' argument do all the r...
Can you show us the Edit links dialog?
PQ should not return 0 for a cell that contains "" (which is not the same as null, by the way). Are you sure the source sheet doesn't simply have the ...
I suspect the issue is in your transform file function.
Without seeing the query we can only guess, so most likely cause I think would be that the column name is not exactly the same as specified in the que...
It is polite to mention cross-posting:
Click on the button with the two down arrows on it at the top of the Content column (to the left of the one you currently have selected in that pictur...
You're most welcome. 🙂