Runtime Error Code 1004

[laks]

Hi

I am converting Excel Templates which were developed in office 97 to Excel 2003.The templates are running fine in office 97 ,but when I run the same template in off 2003 I get the error "Run time Error Code 1004 : Application or Object Defined " and when I tried to debug the cursor is pointing to a cell which contains a formula which add multiple cell values.Can any one throw some light on this why the template which works fine on office 97 is not working in office 2003?.

Quick help is appreciated

Thanks & Regards

Laks

[Bryan Hessey]

Hi

I am converting Excel Templates which were developed in office 97 to Excel 2003.The templates are running fine in office 97 ,but when I run the same template in off 2003 I get the error "Run time Error Code 1004 : Application or Object Defined " and when I tried to debug the cursor is pointing to a cell which contains a formula which add multiple cell values.Can any one throw some light on this why the template which works fine on office 97 is not working in office 2003?.

Quick help is appreciated

Thanks & Regards

Laks

Hi,

The error 1004 is telling you that you cannot do what you are trying to do in the place that you are trying to do it, and the cursor position is not always useful.

Check your assumed access to objects, and define that access where required (ie, for Range(~~ try activesheet.Range(~~ etc), this is a time when the step-by-step is really useful.

hth
---

[laks]

Hi

Thanks for the quick reply.But since my company has upgraded from office 97 to office 2003 I am in a position to convert my entire templates in Excel 2003.
Since there is no flow change in the templates I am just opening it in Excel 2003 and trying to run it to make sure there is no issue due running them in office 2003.There is no single line of code as an addition.

The programme which I am trying to convert contains lot of process but ultimately it does summarisation of the data given as input and gives the output in a presentation format.

[Bryan Hessey]

Hi

Thanks for the quick reply.But since my company has upgraded from office 97 to office 2003 I am in a position to convert my entire templates in Excel 2003.
Since there is no flow change in the templates I am just opening it in Excel 2003 and trying to run it to make sure there is no issue due running them in office 2003.There is no single line of code as an addition.

The programme which I am trying to convert contains lot of process but ultimately it does summarisation of the data given as input and gives the output in a presentation format.

Yes, but not all the code that worked in '97 seems to run well in 2003, you will need to track down any offending lines (and no, I have no idea which they might be, but assumptions as to ActiveSheet seem to be one cause).

The CTRL/F8 (run to cursor) should be helpful to you here.

---

[laks]

Hi

One quick doubt ,is there any limit for the cell holding the reference of the other cells in 2003 ?.Because in my case the cell is referring sum of around 130 cell values.

Quick help is appreciated

Thanks

Laks

[Bryan Hessey]

Hi

One quick doubt ,is there any limit for the cell holding the reference of the other cells in 2003 ?.Because in my case the cell is referring sum of around 130 cell values.

Quick help is appreciated

Thanks

Laks

the limit is 32768 data characters per cell, formula is (from memory) 1024 characters cell formula

---