Application.Match not recognising numerical strings

I have the following If function in an Excel VBA macro whic looks for the value of a defined variable within a column:

Please Login or Register  to view this content.

However, the Application.Match function does not recognise cells that do contain the value of "my_acc" if the value is purely numerical. For example it will find "123456-78(GBP)" but will not find "12345678". I have tried declaring the variable "my_acc" as Integer, and have also tried just not declaring the variable at all but to no avail.

Any ideas?

Many thanks

Are the 'integer' values in cb_range stored as numbers, or as text? With application.match, this matters.

Try this instead:

Please Login or Register  to view this content.

This should be less fussy about whether my_acc and cb_range are matching data types...

Declare my_acc as Variant

Please Login or Register  to view this content.