Thread: Excel 2003 won't run simple code that Excel XP and Excel 2000 will run
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Moses[_2_] Moses[_2_] is offline
external usenet poster
  
Posts: 2
Default 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 QuoteReply With Quote