Private Sub Worksheet_Change problem

Hello all! First off I'd like to thank anyone for any help given. Here goes:

I've got a workbook that has six worksheet templates within it. Each one has a different number of hidden columns. It is used for serial number input from a barcode scanner. The idea is that when you scan a bar code, it automatically duplicate checks against the rest of the entire workbook, but if that isn't possible at least against the rest of the worksheet. The first one that I tried, on the 2 column worksheet worked! This is what the code looked like:

Please Login or Register  to view this content.

With Duplicate_Check2 being:

Please Login or Register  to view this content.

However when I updated this and tried it for the three column template, it doesn't work. Here is the code for that:

Please Login or Register  to view this content.

And Duplicate_Check3 being:

Please Login or Register  to view this content.

What the heck am I doing wrong? It works perfectly for the two column sheet and not at all for the three column sheet. Any suggestions?

Thank you for your time,
-Robb-