loop for date value

[Burt_100]

Hi,
I am currently using the below code to change the text value in columns A, N, Q, R to date and then convert to date using the date value function. I am a bit of an amature @ this but it keeps showing an error @ the start of the first loop "For Each c In ActiveSheet.UsedRange.Columns("A").Cells" stating Runtime error 13 "Type Mismatch", Can anyone help me out with this?

Please Login or Register  to view this content.

[PCI]

I would suggest to use

Please Login or Register  to view this content.

and then to declare variable cell
The error in my code is coming from statement "DateValue"

[Burt_100]

Sorry PCI I dont understand what you mean by declaring the variable cell?

[JOHN H. DAVIS]

Maybe?:

Please Login or Register  to view this content.

[PCI]

Put the "Option Explicit" at the beginning of your code and launch the debug.
It will stops at statement "IsNumeric(cell)" where the variable "cell" is not define
In my code I changed cell by c as I was supposing it was the variable to use