Comments by FusionOz (Top 1 by date)

Thanks for the code above it has helped out some, the issue with it is it is not returning the right number

For example Member Card Number: 6008 9446 4420 2010 translates to Bar Code :2794644202019 what i get from entering the above is a barcode number : 2794644202018 which is not correct, these are the issues i am trying to work out as the code from Excel returns the right number but VB does not