Found function with exact match

[bimo]

Hi Everyone,

I run this Macros to auotmatically find values and return values of the adjacent cell.

the problem is that it is looking for partial match rather than exact match of the whole cell

so Cell.value = "2" and cell.value = "232" are for the purpose of the check, identical.

Can you help please ?

Thanks

Please Login or Register  to view this content.

[Marc L]

Hi,

place cursor on Find statement, hit F1 key and just read ! (LookAt argument)

Other way : Macro recorder is a friend !

[sakmsb]

Hi,

place cursor on Find statement, hit F1 key and just read !

Other way : Macro recorder is a friend !

Yes agree with ^, recording your events carefully and then editing the code is the best way for such things.

[sakmsb]

if you are having issues post recording your macro, plz attach the file with the code so better help can be provided

[AB33]

Use this line

Please Login or Register  to view this content.

Instead of

Please Login or Register  to view this content.

[bimo]

AB33, hat off!! Thanks,