PDA

View Full Version : Sleeper: vba program



rocks12
10-03-2012, 10:44 AM
i have a file in excel (reporty card) where i rate the performances of students based on a test.i want to write a vba program so that individual student's performance is depicted in a chart from the data given.the dates on which student's did not appear for the test shows n/a and it should not show in the chart.i have written the code in the attached file sheet 1
but not getting the desired results.

Bob Phillips
10-03-2012, 01:22 PM
Use a formula of =NA(), not a value of n/a.

rocks12
10-04-2012, 10:04 PM
i tried it but not getting the desired results.

Bob Phillips
10-05-2012, 01:01 AM
Can you explain what that gives you and what is wrong with that as it seemed good to me.