Forum

Hi Berkhan, Welcome to our forum. Can you provide a sample file with your data structure and the full queries you are using? It's hard to recrea...

Hi Janah, In Module2 you have code that can be easily modified to what you need: This section: PDFFile = PDFFile & ".pdf" ' Export acti...

Try the file attached. It will be extremely slow, I personally quit running the code (after processing over 6000 cells in more than 30 minutes), th...

Hi Eduardo, If you try to import data from Artigos.pdf.xls into power query, it will not read the cell value, it will actually import the displayed...

I tested that change on my side and works. I believe the code fails now for the reason mentioned above: that all pivot tables must have the SAME pi...

This this line instead of the one highlighted in yellow from your image: sl.PivotTables.AddPivotTable pvt

Basically, you had most of it. Sub DisconnectAllSlicers() Dim sl As SlicerCache, pvt As PivotTable, wks as worksheet For Each sl In ThisW...

You're welcome. Anyway, it's not about M knowledge. In fact, the double loop is an unnecessary complication, the function can be created without editi...

Do the opposite: aSlicer.SlicerCache.PivotTables.AddPivotTable (pt(i)) (instead of removepivottable) Code should look like below, but be aware that...

Then use the code you have. I have not seen yet the RULES for "proper" highlighting. You have to identify ALL possible scenarios and provide a RULE...

As mentioned, If the merged range has 10 cells, you cannot change the color to only one of them, you have to change the color to the entire merged ran...

I don't understand your message. I provided in previous message a file with the code that compares 2 files, the code will ask you to browse for the fi...

Tip: you can go to your forum profile, and list the topics you have started (or posted into) to find one of your topics, you don't have to start a new...

Hi Zak, You cannot highlight a missing value in a merged range, that is why I asked for clarification. Technically, you can, but you will see that ...

Hi John, It is possible, but not easy. To separate weeks, you can add an index column and a custom column to identify the beginning of another sect...