Forum

Hi Julian, In excel, 1 day represents 1 unit. A fragment of a day will obviously be a fragment of 1 unit. Therefore, if 1 day=1, half day will be =...

No, this is a standard event for this workbook module: Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Ther...

Hi Alan, The code should look like this: (noticed that the code is in ThisWorkbook) Private Sub Workbook_SheetSelectionChange(ByVal Sh As Ob...

Hi Sharleen, Welcome to our forum 🙂 In Excel, first day of week is used, not the last. Same in Power Query, here is a resource for that: Pow...

Hi Anne As you guessed already, it's a simple error, hope the colors will help you see what the text already tells you: We cannot apply operator...

Hi Lena, Declare a variable: Dim Fld as PivotField, Itm as PivotItem Set Fld=ThisWorkbook.Worksheets("Sheet1").PivotTables("PivotTable1").P...

Hi ER, Sorry for the late reply. Not saying it's impossible, but it is not easy to do that. How do you know when a page is "full'? It really dep...

I think your italian english was confusing enough, no need to change the language 🙂 For such tasks you should try the macro recorder. Your code so...

You're welcome 🙂

Hi Anne, I see it as a simple merge, the trick is to add to both tables a custom column with the same number in all rows (the custom column formula...

Hi Mohamed, Is the code used in a regular vb module in your file? that .xlam is an add-in, maybe you pasted the code in that add-in modules, not in...

Hello, my name is Catalin. Excel does not have such options, it needs to use external apps to do this. Even taking a printscreen is not very easy, ...

Hello, my name is Catalin. First, add a column with this formula to determine the age: =(TODAY()-C2)/365.25 If you sort the new column Largest t...

Why would you keep something in E1 other than email address? Sub SendAllSheets() Dim ws As Worksheet For Each ws In ThisWo...

Here is an excellent 🙂 reference: