Last seen: Jun 11, 2026
Using TEXTBEFORE with the same arguments should return the address up to the STE part.
To strip off everything after the last period, you can use Instrrev: Left$(UserForm1.TextBox1.Text & "", Instrrev(UserForm1.TextBox1.Text,...
You could also use: =TEXT(I2*100,"00:00")+0 with the same [h]:mm formatting
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. 🙂