Last seen: May 22, 2025
Let's say the other sheet is named Other Sheet. In A1 enter: zz'Other Sheet'!B1 In A2 enter: zz'Other Sheet'!B21 Then select A1 and A...
You could use INDEX instead - replace TestTab!$H$4 with INDEX(TestTab!$H:$H,4)
Unfortunately I don't think the exact thing you are looking for is possible with VBA. The only place the Sites appear is in Backstage view, not in any...
Why do you need them on the ribbon when you can just pin them to the recent files menu?
Amend the formula to: =GETPIVOTDATA(""&G1,$A$1,"שנים",2016)
You should be able to use something like this, specifying the relevant SP path in the InitialFileName property: With Application.FileDialog(ms...
Dynamic array formulas do not work in tables, though you don't really need a table to use normal pivot tables. You could simply amend your output f...
Not that I'm aware of.
Do you actually open the file they choose after they select it in the dialog, or do you just need the path? Automating the backstage view (File - Open...
Your pictures will overlap, but the basic syntax would be something like this: Dim n As Long For n = 1 To 20 Sheets("GPC" & n).Range("B16...
I meant exactly as I said - if I have an open Explorer window and a file changes size in the selected folder, the window updates automatically.
You're welcome. 🙂
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 ...