Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
making macro resident in memory
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 the program must automatically grab them, apply some functions an write the results into average and %. i can make this simply by usin excel functions. but i must do this with macro. i think i must loa macro to memory in order to do this. but how? please, i need ver urgent help :confused ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
making macro resident in memory
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
Extract portion of formula resident in a cell | Excel Worksheet Functions | |||
Macro Error...OUT OF MEMORY | Excel Discussion (Misc queries) | |||
XP running out of memory when using macro | Excel Programming | |||
Not enough Memory running macro | Excel Programming |