Cawemann wrote:
i must make a table with domains "student name", "student ID", "quiz 1",
"quiz 2", "average" and "%". when i enter values into quiz 1 and quiz 2
the program must automatically grab them, apply some functions and
write the results into average and %. i can make this simply by using
excel functions. but i must do this with macro.


Not clear why you need a macro.
I would enter functions in the average and % column which produce the
desired answers when quiz1 and quiz2 figures have been entered but show as
blank otherwise, e.g.

=IF(COUNT(C3:D3)=2,(C3+D3)/2,"")

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup