Forum

So to clarify, you would need: Sub FormatSlicer(SlicerName As String, SlicerFormat As SlicerFormatSettings) Dim theSlicer As Slicer Set the...

Assuming the format is consistent, you could also use Number.ToText([Header.partnb],"F3")

Thanks Catalin - I didn’t read closely enough!

As Catalin said earlier, those two properties belong to the slicer, so they need to be in the With theSlicer block, not related to its Shape

Did you amend the FormatSlicer code to actually use those new settings?

There has never been a definitive cause identified that I know of but to correct it you need to modify the Normal style (under cell styles on the Home...

Which version of Excel is it? That sounds like a bug that first appeared in (I think) Excel 2007 where the normal style's number format would be chang...

It appears to be down to any chart that has no data - in your original sample file, the Velocity chart had all data filtered out. A simple fix is to a...

I'd use something like this in the worksheet: Private Sub Worksheet_Activate() ' this code is replicated in multiple sheets On Error Resume Next...

Try amending the Chart_Burndown_Axis formula to: =IF(COUNTA(ReportBurndown!$X$2:$X$2)>0, OFFSET(ReportBurndown!$W$2,,,MAX(2,COUNTA(ReportBurndow...

You can write UDFs to use regex. Depending on the nature of the regex, a fair bit can be done with FILTERXML, or new functions like textsplit, textbef...

Hi Shawn, I think you misunderstood my point. In the Select Data dialog, select the PPM series in the series list, then edit the Category axis labe...

Hi Mynda, That was true for the Low and Differential series, but the PPM series was different - see pics: Low series - note axis label values. ...

The axis label range for the PPM series was set to Chart_TPM_Axis, not Chart_PPM_Axis

Generally when I've seen this nonsensical error, the solution involves doing something to force a recompile of the VBA project. For example, add a new...