Problem; Excel 2003 Row Limit(65k) affecting my Excel2007 Macros

Hi Guys,
Briefly, I run a spreadsheet that pulls in financial data from a provider(Bloomberg) and ranks trades according to parameters I set. It compares each stock to each other; therefore with excel 2003 I could enter a maximum of 255 stocks(255^2=65025). If I programmed any more stocks I would get an "exceed number of rows limit"

On Friday I installed Excel 2007. This has 1m rows allowing me to increase my securities sample set to 1000(1000^2=1m).

However when I run this it completes 9% of the calculations before I get an error message. This states "exceeds maximum number of rows 65k". I then get a VISUAL BASIC "run time error 9, subscript out of range message"

It seems that the programme does not realise that I am now running excel 2007. I have saved the sporeadsheet in excel2007(as a .xlsm) and I open it in Excel 2007. I have no idea why it is still giving me a row limit message...

Any Ideas or input would be greatly appreciated...

Thanks

Really need to see the code to offer any more help.

This is probably stating the obvious but it might contain some row count checking code like

Please Login or Register  to view this content.

The 65536 row limit is only per worksheet in Excel 2003, so why not re-code it to use extra worksheets as required?

Alternatively, re-code it to check which version of Excel is running when the workbook opens, see psuedocode below.

Please Login or Register  to view this content.

Thanks for the help. I'll stream through the code and see if I get anything. Don't remember having a limit but you could well be right.

Thanks