| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro not found, but it is there
Forgive me for the improper use of the enter key on the post I just made on
this subject. I have the need to compute the minutes between 2 numbers. I wrote a macro (minsBetween) and put it in the Personal.xls workbook. In the spreadsheet, I have the code... =(PERSONAL.XLS!minsBetween(B5,C5)+PERSONAL.XLS!min sBetween(D5,E5))/60+F5 This worked find for a while, but now when I open the spreadsheet every value gets the #NAME? error. I opened the macro editor, and minsBetween is in Personal.xls. However, when I do alt-F8, it is not listed as a macro... I checked, and I can only find one Personal.xls on any accessible drive. I also tried moving the macro out of personal.xls and into the workbook: still did not work. Help! Jim -- -------------- Jim Conrady |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro not found, but its there | Excel Programming | |||
| Macro cannot be found, but it is there? | Excel Discussion (Misc queries) | |||
| Macro cannot be found | Excel Discussion (Misc queries) | |||
| macro not found | Excel Programming | |||
| Found a macro, but don't know how to use it | Excel Programming | |||
Threaded Mode
