Forum

Try this version: ''--found at/em> Public Sub ShowFilePaths() Dim rootFolder As String rootFolder = SelectFolder If rootFolder = vbNullString ...

Hard to correct a macro that is not visible... 😉

You'll need to add a loop to do the hyperlinks one at a time: '--- copy the array to the worksheet Const START_ROW As Long = 4 Dim pathRange ...

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...