Forum

Hans Hallebeek
@keebellah
Reputable Member
Joined: Oct 17, 2018
Topics: 8 / Replies: 365
Reply
RE: Conditional Formatting between two Times

I don't need you to delet this post, I just suggested you mention it since it is the same file.

2 years ago
Reply
RE: Filter Table and send to filtered values a table as atachment to Oulook

You mention several mails but not how many attachments per mail. Please be more specific else set the macro to save the mail instead of display or ...

2 years ago
Forum
Reply
RE: VBA Error with Real Time Data

Your file contains external links that are not accessible for us outside your environment!!! It links to your gogili12 hotmail account!!!

2 years ago
Forum
Reply
RE: Conditional Formatting between two Times

You could have referred to your previous post where Riny helped you! Sure, it's a different question but basec on the same file, and, does the atta...

2 years ago
Reply
RE: Time Formula

Like this one, never tried the MOD with time substraction. Thanks Riny

2 years ago
Reply
RE: Filter Table and send to filtered values a table as atachment to Oulook

If I take a look at your file (the last one I have here) for each DSP: Filter ASME will send 4 E-mails Filter EGET will send 3 E-mails Filter RAPK ...

2 years ago
Forum
Reply
RE: Filter Table and send to filtered values a table as atachment to Oulook

Or I did not read your question correctly or you did not explain it correctly You will need an extra loop in case there are more than one recipient...

2 years ago
Forum
Reply
RE: Conditional formatting with a list

The formula should be entered WITHOUT the quotes like the COUNTIF you had, just replace that formula with Riny's formula and it works.

2 years ago
Reply
RE: Filter Table and send to filtered values a table as atachment to Oulook

What is now your question? I understand you have an issue but it's not clear from your question and there's nothing in the file explaining what you...

2 years ago
Forum
Reply
RE: Send Excel Table in Mail body based on Filtered data and corresponding email in a separate sheet

I would appreciate it if you could find the time to tell us if the solution/option helped you.

2 years ago
Forum
Reply
RE: formula for Multiple cascading dropdown with auto-populate query

Maybe it's too simply thought but would this answer your question?

2 years ago
Reply
RE: Send Excel Table in Mail body based on Filtered data and corresponding email in a separate sheet

I updated the file you attached and have adapted the code a little. Chandoo's idea is great but when you work with Tables you can use a better appr...

2 years ago
Forum
Reply
RE: Send Excel Table in Mail body based on Filtered data and corresponding email in a separate sheet

Slightly modified code Public Sub mailK() Dim Wks As Worksheet Dim OutMail As Object Dim OutApp As Object Dim myRng As Range Dim list As Objec...

2 years ago
Forum
Reply
RE: VBA to add prefix to cell with >255 characters and retain any character formatting in the cell

Hi John, That the code's slow can also be due to tha fact that your screen updating is still on and maybe you've got automaticl calculaions on. ...

2 years ago
Forum
Page 20 / 25