Convert Excel Formula to Macro Code

I received assistance from NBVC for combining data from two cells. Post https://www.excelforum.com/showthread.php?p=2135144. I need to convert the formula into macro code. I thought I would be able to convert it on my own, but running into some troubles with run time errors.

Here is the Excel formula, which is working fine.

Please Login or Register  to view this content.

.Here is what I am trying for the macro

Please Login or Register  to view this content.

Why is that dot in front of Cells? Is that line part of a With..End With block?

Hello maacmaac,

This macro will join the date using the data in column "A" and "B" of the active sheet. It starts in cell "A2" and continues down to the last entry in column "A". The macro uses advanced pattern recognition to parse and merge the strings in the adjacent cell in column "C". If the pattern is not recognized then the cell in column "C' is left blank. This is much faster and flexible than using string manipulation to achieve the same results.

Please Login or Register  to view this content.

Hello maacmaac,

My mistake. I am still learning the nuances of this. I changed the first pattern. The way I had it written it was only matching when the month and day were the same. That has been fixed. The macro nelow has been added to the attached workbook.

Please Login or Register  to view this content.