Dates recognised when recording Macro, but not recognised when running it.

**Ochimus** · 03-21-2015, 08:17 AM

Attached file has a "CSV" sheet, a "RECORDING" sheet (where I created the Macro step by step), and the "Macro" sheet (run through the button).

The "RECORDING" sheet recognises Cols A and L as dates. Coi M can therefore identify rows where the date in Col L was the day after Col A.

But when I ran the code ("MACRO" sheet), it did NOT recognise Cols A or L as dates, so the analysis shows everything as "No".

Code as follows:

Please Login or Register  to view this content.

Not come across this issue before, but hope someone has the solution?

All advise and help received gratefully

Ochimus150321 Macro Date Issue.xlsm

**simcode** · 03-21-2015, 09:15 AM

Hi, Ochimus
try this codes

Please Login or Register  to view this content.

**davesexcel** · 03-21-2015, 09:22 AM

You can use text to columns again in the date range to convert the date ranges to dates.

Here is you workbook in action
https://www.youtube.com/watch?v=31bAererKCc

**Ochimus** · 03-21-2015, 10:19 AM

Many thanks for both prompt answers.

It's irritating that I actually tried setting Arrays 1 and 12 to "4" yesterday.

No idea why reformatting works as "Stand Alone" but didn't when it was part of the initial conversion.

Ochimus