Problems with Error 13 Type mismatch

[EntropyUK]

Hi all this is my forst post so please be gentle. I am gettng a problem with an Err 13 type mismatch error. My code opens an input file loads an array and looks for a string with in the array. If found it increments a tally cell on the spreadsheet. The code then loads up the next array and evaluates that.

For some reason the code fails about 1/2 way through but I cannot see a reason why. I checked the format using the Type() function and it has returned a string value plus there is no white space so cannot see why Excel cannot see it as a string. Also the value where it fails has been evaluated in earlier arrays.

The only issue that I could possibly see is that it fails at row 65549 and the previous array starts before row 65536. I don't see why this would be an issue as I am using Excel 2010 on XP.

I am just trying to find a initial value as I plan to include more complex searches later e.g. PCs that have App2 and App5. So that is why I have not used Countifs function or another methd.

Input file format
COL A COL B
PC1 App1
PC1 App2
PC1 App3
PC2 App2
PC2 App3
PC2 App4
PC2 App5

Please Login or Register  to view this content.

[Norie]

Where exactly does the code fail?

[EntropyUK]

Sorry, I recieved an error when I tried to post this and initially couldn't see it listed hence the re-post. Can't see how to delete.

[Norie]

Perhaps you could contact a moderator and ask them to delete on of the threads, or perhaps merge them.

In the meantime, where do you get the error?

[Richard Buttrey]

Welcome to the Forum and your acknowledgement of the duplicate posting is noted.

This thread will now be closed, you may continue in your other thread.

Thread Closed.