vendredi 27 septembre 2019

Check if a Cell Contains any Date using VBA

The run down: Coworkers have been using excel an template to fill out some in-house paperwork. There is a Cell that should have a date. But sometimes there are multiple dates and then they will go in other cells, while the original cell will either be left blank or state to see the other section of the worksheet.

Now: They want to have these dates and subject matter compiled on a weekly basis.

What I'd like to do: Is there a way to use Excel's VBA to create an If Then statement to check if there is a date in the original cell? I can't find the Command or function that only checks for a date (Not a Specific Date).

Thanks in Advanced.

Aucun commentaire:

Enregistrer un commentaire