run-time error '1004 Unable to get Match property of WorksheetFunction class

**exl044** · 07-08-2010, 12:34 AM

hello,

i'm trying to write a macro that colors in cells in a table if the number in the cell matches with a number in another column, but i get run time error '1004.

any idea? i tried so many things but it seems that i can't re-use range() in a for loop? can someone please help me??????

exl044

Please Login or Register  to view this content.

**Paul** · 07-08-2010, 01:57 AM

Hi Exl044, welcome to the forum.

Rather than using Application.WorksheetFunction.Match, just use Application.Match. Below is your code with a few minor adjustments and should work as intended.

Please Login or Register  to view this content.

Hope that helps!

**exl044** · 07-08-2010, 02:23 AM

hi paul,

thank you so much for your quick response!! you saved me a lot of time!! everything worked as intended!! i knew what i wanted the macro to do but i was about to give up since i'm a macro newbie and couldn't figure it out. now i can show my boss my new idea. thank you again!!

exl044