Excel Macro not working with excel 2010

[vijay2482]

Hi all,

I have a excel macro written in excel 2003.
This macro is run from my vb.net application.
The macro runs successfully on excel 2003 & 2007 but with excel 2010, I get the below error message:
Execution error:1004
No corresponding cells.

Not sure why this is happening...
Any suggestion, advic,solution will be helpful.

Thanks in advance.

 

[Andrew Poulsom]

There isn't a solution (other than exiting the procedure) if no visible cells are present.

Are you sure that you are using the same workbook in both versions of Excel? What I did is copy your data and macro into a new workbook and saved it as an xlsm workbook in Excel 2007. I ran the macro in Excel 2007 with no problems. I closed the workbook without saving and opened it in Excel 2010. When I ran the macro there were no errors.

 

[vijay2482]

I'm using the same excel in both 2007 and 2010.

 

[Andrew Poulsom]

Sorry, I can't reproduce your problem.

 

[vijay2482]

Mr. Andrew,

Sorry to disturb you.
Can you save the file as xls(2003) and run the macro in 2010 to find if an error is produced.

Thanks for any help.

 

[Andrew Poulsom]

I'll try to do that this evening.

 

[vijay2482]

Thanks a lot.

 

[vijay2482]

Mr.Andrew

Sorry to disturb.
Did you try with excel 2010 without saving?

Thanks in advance.

 

[Andrew Poulsom]

It worked for me with an xls in Excel 2010.