Sleeper: Check CC validation (in excel).

[ermis1975]

I have a column with card numbers...I want to check if are valid.(VISA, AMEX)

[Bob Phillips]

There is an explanation and an example at http://www.beachnet.com/~hstiles/cardtype.html

[ermis1975]

thanks...but I want to check numbers without typing each one in the cell.

[Bob Phillips]

thanks...but I want to check numbers without typing each one in the cell.

But it demonstrates that with the weighting lookup table, the MID functions, the SUM, and then the MOD.

[ermis1975]

ok...thanks!!

I found it!!!

[ermis1975]

Little more help...
I want to insert a vba code and call the function from a cell behind the card. A have a lot of cards to validate.

Thanks

[Bob Phillips]

Little more help...
I want to insert a vba code and call the function from a cell behind the card. A have a lot of cards to validate.

Thanks

can you explain what you mean by '... insert a vba code ...' and '... call from a cell behind the card ...'?

[ermis1975]

Sorry...
I have a list of cards in one column (A). In column (B) I want to validate tham.
Thanks..