Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Weeknum Goes Missing
Hi
I am using WEEKNUM function in a series of MACRO routines. Problem is they work really well than sometimes for no apparent reason I get the #NAME error command. I go back into the Add-Ins Menu, remove the selection on Analysis Tool Pak, go out. Then go back in and re-select then Analysis Tool Pack - it then works again. It took me a little while to work through this fix - and lot of hair pulling!! Does anyone have any suggestions as to what may be causing it? Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing data from table | Excel Discussion (Misc queries) | |||
missing data from table | Excel Discussion (Misc queries) | |||
Missing values in Excel Line Chart | Charts and Charting in Excel | |||
Weeknum | Excel Worksheet Functions | |||
how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) |