To Chip Pearson - Excel 2004 calendar

  • Thread starter Thread starter Andy
  • Start date Start date
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
 
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 (e-mail address removed) .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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
 
Back
Top