Quote Originally Posted by figment
the problem appers to be with your numbers in column A. i when through the 10 SST sheet and retyped all the numbers in column A and now the vlookups that that my macro generates are working. unfortunetly i am not sure what is wrong with your origenal numbers.
I agree that there was something wrong with the numbers but it still wouldn't work for me. I put in just the code for the vlookup w/o the mid() command and it worked. As soon as I put the mid() command back in, it quit working. Any suggestions?

Thanks

Shane