Forum

Hi Helen, Nothing in the code jumps out at me but I don't know what values the various ListCounts take. If they are very large for some reason that...

Hi Armando, I'd just use SUBSTITUTE str = WorksheetFunction.Substitute(Range("A1"), ". ", ". 0") where your title is in A1. Regards Phi...

Hi Robb, I journeyed down a few rabbit holes working on this as there are several ways it could be solved. In the end I decided to use some helper...

Hi Steven, Shockwave Flash is old technology and shouldn't be used. Surprised it's still an option you can choose. Regards Phil

Hi Jason, Can you post the file(s) containing the queries, and any necessary source data, so we can have a look. Thanks Phil

Hi Bruno, This is getting very messy and complicated. I've looked at the 3 files you've most recently supplied and unfortunately that just confuse...

Cross posted to here Do not cross post without linking to the cross post to let us know

No worries Pieter 🙂

Hi Pieter, Please see attached file for solution. The result is on Sheet1. Regards Phil

OK, glad to hear it's working now.

Hi Maarten, It should work fine. What exactly are you experiencing? Can you supply a screenshot? Regards Phil

Hi Bruno, That file doesn't have any of my code in it so I can't see what you are doing and fix the problems. I've already supplied instructio...

Hi Mourad, What are you doing with these files? Power Query might be a better solution depending on what you are doing. Phil

Nothing received.

Glad to hear it's working