Excel 2003 won't run simple code that Excel XP and Excel 2000 will run

Posted to microsoft.public.excel.programming

Moses[_2_] Moses[_2_] is offline

external usenet poster

Posts: 2

Excel 2003 won't run simple code that Excel XP and Excel 2000 will run

I don't get it. Lonnie's solution worked.

Instead of this:

sheets("Data Entry").activate

I used the following code:

dim DE as worksheet
set DE = sheets("Data Entry")
DE.activate

and it worked!

Now why is that? Why did the simpler code work in Excel 97 or Excel
2000 but not in Excel 2003?
Does anyone know? Is there something to learn here?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003?	brigida3	Excel Discussion (Misc queries)	1	January 22nd 06 05:13 PM
Excel 2003 crashes loading excel files created Excel 2000	Jeff Lewin Australia	Excel Discussion (Misc queries)	0	June 27th 05 04:20 AM
Converting VB Code for Excel 2000 to Excel 2003	MarkPirks	Excel Programming	2	January 5th 05 12:37 AM
Code-signing certificate problems in Excel 2000 with Windows 2000	Aaron Queenan	Excel Programming	0	May 6th 04 11:35 AM
Excel VBA Code Execution Excel XP Vs Excel Office 2000	John Flynn	Excel Programming	6	August 24th 03 04:58 AM

All times are GMT +1. The time now is 09:40 AM.

Menu

About Us