Excel macro does not work when saving in Excel 1993-2003 format

Hello there,

I have a problem with a macro that worked fine in Excel 2010, but does not work, when I saved the file in Excel 1997-2003 format.
(I am running Excel 2010 on a VmWare Fusion virtual machine running Windows 7 on my MacBook Pro.)

The structure of the macro is as follows (some lines in between deleted). The purpose of the macro is to display certain rows of the sheet when a cell (F105) has a certain value and hide the rest of the rows.

Please Login or Register  to view this content.

When saving the workbook in 1993-2003 format, I get "Runtime error '13': Type mismatch". Before this, the macro worked fine.


Any ideas how to solve this issue?


Many thanks!

Are you sure that the error is in this code & not the lines that you have removed? Try using EntireRow

Please Login or Register  to view this content.

Also, what is the value in F105?