Last seen: Jun 11, 2026
No it can't. Although Excel's security is not great, the password to open the workbook is the most secure one. You'd need a decryption program.
but Excel does know what the Activesheet is Actually, no it doesn't know. When you are writing the code, the compiler doesn't know what kind of s...
Your existing code used Field:=7 so I used the same. If your table layout might change, then you can get the index from the listcolumn like so: ...
Nothing attached, but for 64 bit you need to change the API declaration. This should work on 32 or 64 bit: #If VBA7 then Private Declare Pt...
You didn't say what the error is? Are you using 64bit Office?
This may be a bit overkill as it refreshes the desktop too, but it's the simplest method I could think of offhand (though my windows refresh automatic...
You could do something like this (I assume you will expand your table for the other two variables, but I haven't added the lines for those): S...
Yes, using a string variable is the cause of the problem. When you write back to another cell, VBA will interpret the date using its default US locale...
Yes, you can simply use the <> operator: ActiveSheet.ListObjects("InputTable4").Range.AutoFilter Field:=7, Criteria1:="<>Closed/Tr...
The binding context. Anything late bound (eg any property that returns a generic Object type) will not provide intellisense since the compiler doesn't...
Your workbook code is password protected, which doesn't really allow people to help you easily. Anyway, the most likely cause is that nothing matches ...
Yes, it should be. (can't really say more on the information given)
You could also use List.Zip and then Table.FromRows: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Custom1 = Table.Transform...
You could use something like this: Sub Main() Dim ws As Worksheet Set ws = ActiveSheet Call AlignSlicersVertical(ws) End Sub Sub AlignSl...
FWIW, I'd still recommend handling a blank list, just do it differently: =OFFSET(Fruits!$N$10,,,MAX(1,COUNTA(Fruits!$N$10:Fruits!$N$999)),1)