Last seen: May 22, 2025
It is the version. If Excel 2016 has the problem, I'd guess you are using a function that is restricted to subscription versions/Excel 2019. Why don't...
It's never really a good idea to change the defaults from whatever the user has set, since if your macro fails for any reason, you will have messed up...
Sunny has already given you a great answer, but since I'd done it anyway, and in case your data set isn't sorted, you could also try this: Sub...
It looks like you just need SUMIFS: =SUMIFS($B:$B,$D:$D, "Yes", $C:$C, ">="&A2, $C:$C, "<"&A3 )
Which version of 2013? If it's Professional Plus, or Excel standalone, you should have Power Pivot. If it's a different version, you cannot use it and...
Depending on what version of Power Pivot you have, you may be able to use CONCATENATEX for this:
The Text property just returns a String, which doesn't have formatting. You'd have to parse the Characters one by one and add the relevant HTML or RTF...
You could use a class, declare a MailItem object WithEvents and handle its Close event, checking its Sent status then, as long as you can set a refere...
Probably something like: =IFERROR(VLOOKUP($BC$1;$CD$3:$CF$14;2;FALSE)&" - "&VLOOKUP($BC$1;$CD$3:$CF$14;3;FALSE);IFERROR(VLOOKUP($BC$1;...
It seems to be a limitation in Mac Excel (I"d call it a bug).
This should be the same effect as your original code but pasting column widths too: Sub SplitIntoSeperateFiles() Dim OutName As String OutName...
It sounds like you just need to change the formula to: =IF(C4=”Staff costs (direct and external)”,M4 *0.15,0)
It sounds to me like a pivot table would be ideal for this. Or Power Query, if you have it.
Try modifying the copy/paste section to this: With FilterRange .AutoFilter Field:=NameCol, Criteria1:=UniqueNames(Index) .SpecialCells(xlCellT...
You could use something like this: =SUMPRODUCT(0+(INDEX(B2:E2,1,N(IF(1,{1,4})))="Y")) which will check the 1st and 4th columns of the ...