Runtime Error for VBA

[tussiam]

Greetings VBA Guru's

a little bit stuck here with my VBA's, that every time I select data through EDIT button excel shown runtime error [I attached the file in this post], I tried everything but it does not work, please help me...

thank you.
Ardi

[torachan]

Put 'Option Explicit' at the head of your code.
Define all variables.
You appear to have a variable that cannot find a value.

[tussiam]

Hi Torachan,

I've put the 'Option Explicit' at the head of my code, yet the problems remain the same, here's the code:

Please Login or Register  to view this content.

[bakerman2]

When using Application.Match you need to declare your variable TargetRow as Variant because it must be able to hold an errorcode (when no match is found) as well as an integer.

After that you use IsError to determine the value of the variable.

Can't open References because it's protected.