Application-defined or object-defined error

[msolari]

Hello All,

So I am parsing a file comparing sorted names. If the name has special characters like #, its seems to give me an "Application-defined or object-defined error". Is there anyway to stop this from happening without going into the list of names and taking out characters? Below is the code snippet providing the error. Any help would be appreciated. Thanks!

Do While nameRng = nameRng.Offset(1, 0)
                Set nameRng = nameRng.Offset(1, 0)
                z = z + 1 ' Sets z for later
            Loop

[Norie]

What is that code meant to do?

[msolari]

Thanks for the post. In the larger scheme I am counting similar names in a row. Its the nameRng comparing to the nameRng below it that will throw the error (if the name below it has a # at the beginning of the name). I have tried changing the column to text to no avail. I don't want to remove the "#". I believe it may be treating the name as a formula, but I'm not sure.

[Norie]

I'm not sure that's the problem.

Have you checked the values of all the variables when you get the error?

If you want to count based on criteria why not use Application.CountIf?

[msolari]

I'm not using Application,CountIf because I am also referencing up to 3 more columns to see if I want to count that name. I have checked all the values (names) and I am positive that it's the "#" at the beginning of the name as the code runs and works perfectly when they are removed.

[msolari]

This may help after some investigation, I believe its a formatting error cause these names are showing up as #NAME?. I believe it's not the "#" but an actual cell error.

[msolari]

Funny thing is, I am not using any formulas in any of the name cells.

[Norie]

That might cause problems but I would have expected an error like 'Type mismatch...' rather than the one you describe.

Where are you referencing the other 3 columns?

Also, what does namerng refer to?