Posts by dangelor

    Possibly...

    Possibly...??

    DateValue takes a string that looks like a date and converts it to a date.


    So the "01-" is the first day, and the "-20" is the year 2020. Put them all together and you get "01-jan-20" for January 1, 2020.


    The 31 is just to resize one cell to 31 cells, using it to clear any old dates.

    Possibly...

    Not that familiar with UserForms, but possibly...

    If this isn't a solution, I suggest starting a new thread.

    Possibly...

    Sorry for the late response...

    Possibly...

    Possibly...

    A few possibilities for failure:


    Line 3: Duplicate declaration of the variable r

    Line 34: If the test fails (which it does in 5 of the 8 rows of data), no email will be created.

    Line 54: There is no range assigned the variable rng in the RangetoHTML function.


    I suggest adding Option Explicit to the top of your code modules and removing all On Error Resume Next statements to help in debugging your code.