Error: "Unable to get the interior property of the range class."

Hello all,

I created an Excel 2003 workbook (.xls extension) with many macros on a machine running Excel 2007. Everything functions correctly in Excel 2007 on several different machines, however a VB errors occur when trying to use the workbook on two different machines running Excel 2003. The specific error is "Run-time error 1004. Unable to get the interior property of the range class." I've tried various solutions (thanks, internet!), but all produce the same error. I was not able to find information about the Range class being different in Excel 2003 than in Excel 2007.

The workbook makes extensive use of named ranges so it would be a hugely difficult task to change them to explicit cell references.

I would appreciate any suggestions you have on resolving the error.

Please Login or Register  to view this content.