Last seen: May 22, 2025
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)
There are quite a few places it could occur. For example, you have a lot of comparisons like if [Total] > 1 then which would cause that error if th...
From your description, the table is not on the active sheet, which would cause the error. You could use: Private Sub Submit_Click() Dim LogTa...
Q1: No. Q2: Why do you have two forms that do essentially the same thing? You can pass a form as an Object to a routine - just pass Me from the for...