To Chip Pearson - Excel 2004 calendar

A

Andy

Hi Chip,

I downloaded the Excel calendar from your website, tried it and had problem,
the line causing the problem is

Range("StatusCell").Value = Format(TempDate, "mmm d, yyyy") _
& " " & Format(DayOfYear(TempDate), "##0") & _
NumberSuffix(DayOfYear(TempDate)) & " day of year." & _
" Days From Now: " & Format(DateDiff("d", Now(), TempDate),
"##,##0") & _
" (Workdays: " & _
Format(Evaluate("NETWORKDAYS(" & """" & Format(Now(),
"mm/dd/yy") & _
"""" & Application.International(xlListSeparator) & _
"""" & Format(TempDate, "mm/dd/yy") & """" & ")")) & ")"

I'm using Excel XP and the problem ocurred on date Feb 19, 23, 25, 27 and
29, year 2004, it happened also on Feb 17, 2005. Those are the 2 months and
years I happened to click on by random. I love the program and would love to
know what I need to do to fix it.

Thanks
Andy
 
C

Chip Pearson

Andy,

What error are you getting? Are you absolutely sure that you have
the Analysis Tool Pack installed? Does the problem occur on all
dates or on only specific dates. Did you change any of the
values in the HList or Setup pages?

I can't replicate your problem. You can send me the file that is
causing the problem to [email protected] .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
A

Andy

Hi Chip,

1- The problem was run-time error '13':
2- To the best of my knowledge,the Analysis Tool Pack was installed. It was
spelled as Analysis Toolpak in the add-in, it was checked. I assume the 2
names refer to the same thing.
3- The problem occurs on some dates only.
4- I did not make any change on the HList and Setup

I'm sending the file to you. I have added a sheet "Need Help" to show the
screen shots captured.

Thanks & regards
Andy
 
Top