Run-time error: '13' Type mismatch

[Roller]

I have a basic data input sheet which users populate columns B through W with data. In hidden columns X through AS, I have a formula that returns "true" or "false" that checks the data values in each of the corresponding columns based on individual data requirements. In Column AT, I have a simple =AND( ) formula that returns a 1 if there are any false values in X through AS. I also have a formula in a named range that is used in a macro for this sheet (see below). The macro below is designed to only show the button when all the data fields meets the requirements. The button creates an XML file written to the users local drive (this part works fine).

My problem is: some users are getting the run-time error '13': type mismatch when inputting data. Others (including myself), do not. The data is simple address and payment information (like from a check register: Name, address, amount, reason for check payment, etc.). Any reason that would cause some people to get this error while others do not? Users can input data or copy/paste data.

Formula: =IF(SUM(CheckDataInput!AT:AT)=0,TRUE,FALSE)
Macro:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Selection.Count = 1 Then
Select Case Target.Address
Case Range("ShowMacroButton").Address
If Range("ShowMacroButton").Value = True Then
Sheets("CheckDataInput").Shapes("Button 1").Visible = True
Else
Sheets("CheckDataInput").Shapes("Button 1").Visible = False
End If
End Select
End If
End Sub

Thank you, in advance, for your consideration in helping resolve this.

 

[Dan Waterloo]

Are users possibly using different languages and if so are there any dates in the data?

 

[Roller]

We've instructed users to "paste values". Also, there is 1 date field and 1 postal code field. The feedback says this error occurs after inputting the postal code. The date field is the 3rd field whereas the postal code is the 13th field to enter assuming they are entering data left to right in order.

 

[Fluff]

Assuming your named range contains this formula
=IF(SUM(CheckDataInput!AT:AT)=0,TRUE,FALSE)

Check that the users who are getting problems don't have an error value in that cell.

 

[Roller]

So far, the only errors that I have been able to create to replicate the error is if someone is trying to copy an unknown cell reference (i.e. #REF!), but numerical errors or errors that don't meet the requirements (i.e. character length) just return False in their corresponding columns as it should (and would give me a sum result > 0). I'll keep digging but still trying to get more examples. Thanks!

 

[Fluff]

If you have any error values in col AT, then this formula
=IF(SUM(CheckDataInput!AT:AT)=0,TRUE,FALSE)

will return that error value, which in turn will give you a type mismatch error in your code.
Which line of code is highlighted when the error occurs?

 

[Roller]

This is the line of code highlighted on the error:
If Range("ShowMacroButton").Value = True Then​

 

[Fluff]

Is the named range range a single cell?
If so, then it almost certainly contains an error.

 

[Roller]

Yes, it is. I'll look for an error in their worksheet (once they send me a copy) but it seems odd that in a postal code field where I am only checking for the number of characters in the cell it would cause an error. Thank you.

 

[Fluff]

Ok, for reference you can simplify your formula to
=SUM(CheckDataInput!AT:AT)=0
No need for the IF function