Gannt Chart

[coliervile]

I've got the following file that for some reason when the data is entered it won't fill in the Gantt Chart correctly. On the "Revised" worksheet when a lower case "z" is in column "B" it won't fill the Gantt Chart with the correct data. All of the other letters work fine.

Best regards,

Charlie

the password is PASSWORD

[lucas]

Charlie,
I didn't dig into this very deep and couldn't tell if it changed anything but try this...

In the code for the worksheet Revised just below Option Explicit add Option compare Text....

Option Explicit
Option Compare Text

[coliervile]

Lucas thanks for your help and suggestion. I did try your idea, but it did change my problem. Any other suggestions?

Best regards,

Charlie

[Andy Pope]

Change the content of C50 to be
01/01/1900 00:00:00

[coliervile]

Thanks Andy Pope for helping. Are you saying change the cell format?

Best regards,

Charlie

[coliervile]

Thanks Andy Pope I figured out what you were referring too. Have a good day and thanks again.

Best regards,

Charlie