Christian_Ku
Board Regular
- Joined
- Sep 10, 2007
- Messages
- 102
Hello,
I came across a problem with my macro and decided to record a macro and see how excel did this, the result:
however, when I run this macro i get the 1004 error on the last line?!
The last line of code was also present in my own and therefore I tried to record one to see what I was doing wrong.
Anyone an idea because a macro that is recorded by excel itself that does not work is strange in my view.
I came across a problem with my macro and decided to record a macro and see how excel did this, the result:
Code:
Range("G14,I14").Select
Range("I14").Activate
ActiveSheet.Shapes.AddChart.Select
however, when I run this macro i get the 1004 error on the last line?!
The last line of code was also present in my own and therefore I tried to record one to see what I was doing wrong.
Anyone an idea because a macro that is recorded by excel itself that does not work is strange in my view.