Macro won't work in 2007

[dhughes5]

Hello,

I created a macro awhile ago to perform a pretty simple function in Excel 2003. The macro just goes down two specified columns and if a date is entered it is checked against whatever today's date is. If today's date is past the entered date the cell turns red, otherwise the cell is green. The macro worked flawlessly in Excel 2003. However now in Excel 2007 whenever the macro run a Runtime Error 13 occurs. Here is the code

Please Login or Register  to view this content.

The error occurs at the

If c.Value <> "" Then

line and is noted with Error = 2015

Thanks in advance for any advice!

[Palmetto]

Your post does not comply with Forum Rule #3 regarding the use of code tags for VBA code. Please amend your post to add the code tags, after which solutions will be suggested.

Rule #3

Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button. For more information about these and other tags, click here.

[JimmyA]

Hi Mate

The only time I get this error is when one of the cells does not contain a date or time but is populated.

E.g. I just put the letter "a" in one cell and that is when I got the error.

It could be more to do with the data than the macro. as it runs fine on my version of Excel

Hope this helps

Cheers

Jim

[DonkeyOte]

Further to the prior post and in response to your earlier assertion of debug at:

Please Login or Register  to view this content.

the above would occur were the value an Error

To correct both issues you could perhaps change the above to:

Please Login or Register  to view this content.