type mismatch on application.run

[DevanG]

Application.Run ("'fundselect.xls'!ManagementFee.mgmtfee")

This returns as a type mismatch. it goes filename!module.sub -- this works for another sub RIGHT below it. same syntax.

[Kenneth Hobs]

Most likely, you should not have used ()'s. If you do, prefix your command line with Call.

[DevanG]

Most likely, you should not have used ()'s. If you do, prefix your command line with Call.

no difference.. Calls don't work either -- object error

[Kenneth Hobs]

Then you have an issue that was not considered in your Sub. We would need to see the Sub code and/or a workbook to test.

[DevanG]

Then you have an issue that was not considered in your Sub. We would need to see the Sub code and/or a workbook to test.

OK. Well i didn't consider the sub to not work since its part of someone else's workbook that works fine. Its not private, so I'm just borrowing it. The line after this one is the same for another sub in the other workbook.