NAME? in cell with formula 1

[vba317]

Today I started getting an #NAME? error in any cells that I update in Column C. This is the spreadsheet that I added the code form yesterday. The formula that is in cell B8 the formula is =WORKDAY(B5,C8-1).
The cell B5 has the date in it 1/31/2013. The cell C8 has the number 1 in it. Somehow is the worksheet change event I added in yesterday messing things up?

Tom

 

[SkipVought]

Hi,

Exactly what formula is in the cells on question?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[vba317]

=WORKDAY(B5,C8-1)

the code in the change event is

Private Sub Worksheet_Change(ByVal Target As Range)
'Excel Worksheet Change event
Application.EnableEvents = False
If Not (Application.Intersect(Target, Range("D8:H105")) Is Nothing) Then
    With Target
        If Not .HasFormula Then
            .Value = UCase(.Value)
        End If
    End With
End If
Application.EnableEvents = True
End Sub

 

[SkipVought]

I am confused. You stated, "Today I started getting an #NAME? error in any cells that I update in Column C." Than you stated, "The formula that is in cell B8 the formula is =WORKDAY(B5,C8-1)."

That is why I asked what the formula was, as B8 is obviously not in column C.

Your workday formula is not in column C where you are getting the #Name error???

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[vba317]

The formula is in the B column and that is where the NAME error is.
The C Column is where I am changing the number to represent what workday of the month it is.

Tom

 

[SkipVought]

You may need to re-load Excel, as it seems that an object library may be missing.

Does this happen for other date formulas?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[vba317]

You are correct. How do I reload? I tried to uncheck and than recheck the analysis toolpak and th analysis toolpak vba but this didnt make a difference.

Tom

 

[combo]

What is the excel version and what are security settings?

combo

 

[vba317]

I had IT remove excel and reinstall it and now everything works great. Thanks Skip once again.

Tom