Greetings - I recently wrote a macro invoking solver. I added a reference to Solver in VBA and it works fine on my machine. I emailed my excel file to a colleague and directed him to add the reference to the Solver in the VB developer and he keeps getting the above error. The code works perfectly on my machine. Any guidance if there is a quick fix to this problem would be greatly appreciated.