Last seen: May 22, 2025
Is it possible to replace "GAM83MALE" with a cell reference? Yes. You could use INDIRECT(cell_reference) in the function call, assuming that the ...
Your Application.Goto line can't work since you can't use brackets in the name of a range - so it can't be called "ArrayMortality()" - and you can't s...
You could use code like this: Sub ListTable1Queries() Dim q As WorkbookQuery For Each q In ThisWorkbook.Queries If InStr(1, q.Formula, """Table1"""...
You could add an Index column starting at 1. Then add a calculated column using the index column thus: Number.Mod([Index]-1,15)+1) whi...
You can specify those as arguments for the protect command: Sheet1.Protect Password:="password here", AllowFiltering:=True, AllowUsingPivotTab...
It sounds like a bug, but try breaking that line up into separate steps like this: Dim sh as Object Set sh = ActiveSheet.Next sh.Activat...
Sorry, it was implicit in this sentence: "the first part of the formula checks if the number of values in the result array is less than the nu...
COUNT(MODE.MULT($B$2:$D$21)) tells you how many numbers are returned by your original function (7 in this example) ROWS($A$1:$A1) returns a sequenc...
If the code is in a worksheet code module, then Range("UP84Male").Value would always refer to a range on that worksheet (this seems unlikely as you'd ...
The error is not actually returned by the formula, which is why IFERROR doesn't work, it's because the result array has fewer 'rows' than the range yo...
I would strongly suggest that you keep the currency code and the actual value as separate cells.
You're missing about 9 End If lines, since you have nested all your If clauses within each other. It's hard to be sure without the workbook (all you n...
Did you mean something like this perhaps?
and will also only work if the items are actually in the dataset at a completely unfiltered level, which it sounds like yours aren't. As lon...
Try changing the settings for that field to 'Show items with no data'