Posted to microsoft.public.excel.programming

Leon[_4_]

external usenet poster

Posts: 3

Excel 2000 and 2003

I encountered some problems with excel code developed in excel 2000 and used in excel 2003. Problem was reduced to one line of code:

Worksheets("MKS").Rows(2).Calculate

I took two similar files developed in excel 2000, reduced them to one singel worksheet with no data and one macro with code specified. The confusing fact is that it works in one file and doesn't work in another (Run-time error '1004': Calculate method of Range class failed). Both files are OK in excel 2000.

Any idea?
Leon

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2000 and Excel 2003 in Office 2003	Emon	New Users to Excel	0	December 21st 06 09:11 AM
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003?	brigida3	Excel Discussion (Misc queries)	1	January 22nd 06 05:13 PM
Excel 2000/2003 conflict	nyvirus1	Excel Discussion (Misc queries)	0	July 22nd 05 01:45 PM
excel 2000 and 2003	cwwolfdog	Excel Discussion (Misc queries)	1	March 29th 05 01:32 PM
Excel VB 2000 not working in 2003	A Lost Soul	New Users to Excel	2	March 22nd 05 01:21 PM

All times are GMT +1. The time now is 08:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us