Excel confusing '1' and '10'

Hi,

I have a macro that prints out names or people who are in designated groups. Two of the groups are called:

Gp 1
Gp 10

The macro prints out the people in Gp 10 perfectly fine. However when it prints the names in Gp 1 it also includes the ones listed in Gp 10.

I suspect this is something to do with it confusing the numbers 1 and 10. I’ve checked the formatting and all the cells are ‘General Format’, so there’s no obvious clash.

Anyone any ideas (Aside form changing the Group name!)

Thanks

Originally Posted by JBeaucaire

Is it a secret macro or do we get to actually see it? (nudge)

The workbook AND the macro would be to golden goose.

Hi...I'll post the macro but it would take too long to remove private info out of the rest of the spreadsheet (and replace it with working dummy info)...I'd have posted it in programming, but i thought it might be something to do with the number formatting rather than the macro as it find all the other groups and names perfectly well. Anyway, this might be of help, or it might not Thanks

Please Login or Register  to view this content.

The concatonated info it pulls the information from (on another sheet) reads as follows.

Please Login or Register  to view this content.

if this isn't of any use ill just change the group names