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...s-v3-2007.xlsm

Thanks
Thiru