Macro Wont Run On Excel 2007

[wayneshirley]

Hi there,

I have a macro that was developed using Excel 2003 (TB.xls). Recently I have upgraded to Excel 2007. Each time I run the macro an error message appears:

Significant loss of functionality
This workbook contains data in cells outside the row & column limit of the selected file format.

Another person in my office uses the same macro, originally with Excel 2003 but now with Excel 2007 and it works perfectly on her PC.

Any ideas please?

 

[jkpieterse]

I would suggest to step through the macro (Alt+F8, select macro, click step into, start hitting F8). Make sure you make the VBA editor window small enough so you can see a part of the Excel window. Now keep paying attention to the excel window, check if what is happening is epxected.

 

[wayneshirley]

Hi Jan,

Thank you so much! I didn't know about stepping into (but do now) and I found the problem. It seem a piece of code that was there to delete junk was deleting everything.

This code works on Excel 2007 but apparently not on Excel 2007.

Thanks again.

Wayne.