Forum

No worries. After the set rng statement modify your code to this rng.Interior.ColorIndex = xlNone For Each zelle In rng If zell...

Hi Chong, See attached workbook. Regards Phil

Hi, Can you supply the workbook please. Phil

Hi Chong, Do you have to use VBA? have you tried Conditional Formatting? Regards Phil

Hi Tim, The articles are referring to Outlook on Office 365. I assume that's what you are after? Yes unfortunately to get Excel to connect and ...

Hi Tim, I haven't done this myself but you can do this It does not appear to be a trivial process. Regards Phil

Hi, there's no file attached. Regards Phil

Hi Kevin, If you use Catalin's code but modify this line to open the text file as UniCode rather than ASCII you might find it keeps your accented c...

I think the issue is more to do with the DB being in the USA than you using VBA. If you are doing database operations remotely like that you must exp...

So attaching a workbook with VBA (SQL) in it to your forum comment gives you an error? Have you clicked on the Attachments button below and tried add...

No worries Steve

Good job Alan, well done 🙂 For anyone else reading this, this article might help Excel IF AND OR Functions

Hi Hooi Thin, I'm not sure why you can't add the SQL (it's just VBA in a workbook). In your loop you are doing a SELECT, so you are doing that 5...

Hi Steve, You're doing a string comparison with Add1.Text > Available1.Text rather than comparing numeric values. Try using the Val() functio...