If you use the VBA Menu >> Debug >> Compile, it will tell you that there is a type mismatch in the VLookup Line.



Because you have declared MyDesc1 as a Range, but Vlookup returns a Value.



Debug>> Compile is the first step in troubleshooting. I use it many time while writing a single sub.