PDA

View Full Version : Solved: Help! Help! Gannt Chart



coliervile
11-04-2007, 02:34 PM
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. :banghead: :dunno :bug: :help :mkay

Best regards,

Charlie

the password is PASSWORD

lucas
11-04-2007, 03:32 PM
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
11-05-2007, 02:17 AM
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
11-05-2007, 04:00 AM
Change the content of C50 to be
01/01/1900 00:00:00

coliervile
11-05-2007, 04:29 AM
Thanks Andy Pope for helping. Are you saying change the cell format?

Best regards,

Charlie

coliervile
11-05-2007, 04:36 AM
Thanks Andy Pope I figured out what you were referring too. Have a good day and thanks again.

Best regards,

Charlie