itemnocol

  1. bobkap

    App Match Error 2042

    I have the following code in my macro: itemnocol = Application.Match("Item#", Worksheets("Prices").Range("1:1"), 0) banana = Application.Match("Dist Price", Worksheets("Prices").Range("1:1"), 0) I get the correct answer for "itemnocol", but using the exact same wording, I get an "Error 2042"...

Some videos you may like

This Week's Hot Topics

Top