match function, iserror

[Decar]

Hi,

I'm trying to "match" values from one table in another and if there is a value not in the table it should do something. The loop works but the match function does not work properly.

I can not set Search1 equal to the match function which I would like to do as it makes the code so much easier to read/adjust

and

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Leith Ross]

Hello Decar,

Please post a copy of your workbook. It will be easier to isolate the problem that way.

[Decar]

Thank you Leith,

after catching a break and looking at it again I found my mistake. The ISerror method was new for me and I did not think enough about how the output is "true/False" so it basically told the range to be in row "true" which makes not much sense for VBA...

Next time I'm going to add a workbook.


regards

[Leith Ross]

Hello Decar,

You're welcome, although I didn't do anything.

Thanks for posting back with the solution. Glad to know that you have the macro working now.