Forum

Hi, Data view is limited in editor, will never load all data there. You have to scroll down untill you see the last row-1000, then the editor will ...

Hi Steve, It is possible, but definitely not the right way. A pivot will be much faster, see attached.

Hi Kevin, How would you calculate that in normal excel table? Hard to see what you mean. Why the count for employee A should be 0 in both periods 2 an...

At the end of my previous message, I provided the LogRow procedure, make sure you add it to your project. Not seeing it in your screen, that's also wh...

Hi Azid, Instead of: " from " & PreviousValue & " to " & Target.Value use: " from " & IIF(PreviousValue<>"",PreviousV...

Can we see your file structure? A sample file is best if possible.

To add date and time, replace: Application.UserName & " changed cell " & Target.Address _ & " from " & PreviousValue & " to " &...

Much clear then before. "Expression.Error: We cannot apply operator & to types Text and Number." That happens because StartPeriodParam is a nu...

Replace: With OutlookMail .Display with: With OutlookMail .Send And remove this part: If DisplayEmail = False Then .Send End I...

Please paste the code provided UNDER the End Sub line of your existing code, NOT inside the procedure you have. The code you have pasted above does...

Unfortunately, nothing you say is reflected in the file: the query is not taken from sheet, only a single parameter is used in the file you attached, ...

Hi Chantal, You can use the code below to send all sheets one by one: Sub SendAllSheets() Dim ws As Worksheet For Each ws In ThisWorkbook.Wo...

Hi Alex, The Outcome sheet is not realistic, in a table there cannot be multiple columns with the same name. See the file attached, the result i...

You already have the syntax needed to read the text from an excel table cell: SQLString = Excel.CurrentWorkbook(){[Name="TablenameOrDefinedName"]}[...

Short answer: No. There are no events associated to slicers that can detect if a user right clicked on a slicer.