View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming, microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 422
Default Excel 2007 VBA problem

Try
Replacing: Activesheet
with:
Sheets("MySheet")

my 2 cents...


"teepee" wrote in message
:

Hello

Could any knowledgable person please help.

I try to run a VBA code that woks fine in Excel 2003 and it crashes in 2007.

The offending line is

ActiveSheet.ChartObjects("Chart 542").Activate

What could possibly be wrong with that?

Is it me or is Excel 2007 not there yet?