Excel 2007 VBA Error #450

Hi

I have created a macro that works perfectly in 2010 but when I try to run 2007 it pops up an error message "Run-time error '450' Wrong number of arguments or invalid property assignment'. I use solver addin - I have attached the excel file - In that sheet called "Multilinesup" and the macro button is "Run Optimizer".

Please help.

I'm unable to upload the file here as it exceeds 1 MB so below is the direct link

http://excelbyjoe.com/MEF/wp-content/uploads/2015/07/MLB-Optimal-lineups-v3-2007.xlsm

Thanks
Thiru

Originally Posted by Alf

Thanks Arlette

Alf

Alf Please Help...Please...Please...Please....Please