Forum

Hi Julien, Pleas see attached file. Note that the last step in the query is to filter the text string "null" from the merged column. This is be...

Hi Deepak, Please refer to this Please supply a clear explanation of your problem and include a workbook and some examples of the expected result...

Hi Sally, As Purfleet says, sounds like you have the data in a table. When you change a formula in a cell this change is copied down the column. ...

Hi Marsil, You need to set a reference to the Microsoft Outlook 16.0 Object Library in the VBA editor. Sorry I thought you'd already done this as ...

Hi Chris, Can you supply the workbook so I can try to recreate the issue. Have you tried loading a table or creating a connection only just to s...

Hi Jacek, I'm not clear on what result you actually want. Is the result table in your image what you want? Or is this what you end up with when t...

Hi Chris, The topic title says 'when updating Power Query' - but the link is talking about connecting a query to the data model. So how exactly ...

Hi Corrie, no file attached. regards Phil

Hi Marsil. See attached file. From your image it looks like you want emails that are not in your default email account. In which case you need to ...

no worries Mark. You can copy/paste the loop into the ShowProgress sub to create an artificial delay - see attached. Though I'd be happy if my c...

Hi Alistair, What is your experience of VBA? Can you look through my code and see what it is doing? It boils down to: 1) Reading a row of da...

Hi Carlos, No file attached. There's a video here that shows you how to attach files Regards Phil

Hi Dan, Please read the forum rules Please start your own topic rather than adding to an old one. Please describe your problem in detail r...

Hi Alistair, See attached file. I've made the potential positive so the bars are above the x-axis. This requires Office 365 as it uses dynami...

Hi, What this section of code (in Reset) is doing is populating the list in the main section of the form. It's loading rows from the sheet. If...