Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How come code written by a macro won't replay in excel 2008?
Hi all,
I recorded a macro and selected a chart sheet and the chart on it and it wrote the code: ActiveSheet.ChartObjects("Chart 1").Activate I then rerean the code and was kind of surpirsed when the code came up with the message that the item was not found. There seems to be a difference between the code when it is recorded from a macro and when it is written which seems wrong to me, if the object oroducres the code in the macro when selected why on earth will it not select when it is run back, I am somewhat nonplussed! I was pretty proficient at programming excel 2003 but the latest version seems to be a lot less user friendly am I right? Thanks and regards, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple VBA Code written in Excel 2003 not working in Excel 2000 | Excel Programming | |||
Macro written with VB in Alphacam. How do I put that in Excel? | Excel Programming | |||
Problem with VBA code written in Excel 2002 working in Office 2003 | Excel Programming | |||
Compiling Excel 2003 application written in VBA 6.0 Code | Excel Programming | |||
Userfrom code in written in Excel 2000 running in Excel 97 | Excel Programming |