Last seen: May 22, 2025
If your rows are all next to each other (or even just evenly spaced out) you could also add a loop to makro1: Sub Makro1(ByVal y as string, By...
Cross-posted, and seemingly already answered, here:
Use <uI style="*/uI> in the find box and leave the replace box blank.
If you're using syntax like $A$1:INDEX(...), with the INDEX on one or both sides of the colon, then it is semi-volatile which means that it will recal...
I used a function to expand any lists in the column (and occasionally, lists within those lists). I'll have to have a look at the web page output and ...
Is this the kind of thing you wanted?
Well that escalated quickly! 😉 Just FYI, it's really not a great idea to just put an error handler that exits silently at the top of your code - m...
Shapes don't have a LoadPicture method. You'd need: ActiveSheet.Shapes("Rettangolo con angoli arrotondati 2").Fill.UserPicture ActiveWorkbook.Path ...
You have a missing reference. With that project active in the VBE, click Tools - References and look for one (or more) of the checked references that ...
You could just add SUBSTITUTE to your INDIRECT instead of replacing the spaces in the actual text - eg: =INDIRECT(SUBSTITUTE(A2," ","_"))
You could use a measure just for active sales - eg =CALCULATE([Total sales],FILTER(dimAccounts,[Year selected]>=max(dimAccounts[Year - star...
The method seems quite temperamental about its argument types. I'd suggest: Dim pf As PivotField For Each pf In ptObject.RowFields ' Create s...
Why do you have 8 different Case statements in ClearForm that do basically the same thing? A simple solution to your issue would be to add the...
Your workbook didn't attach...
This is still unnecessary: If slc.Name = strSlicerName Then Set slc = ActiveWorkbook.SlicerCaches(slc.Index): Exit For slc already is the slicer...