HELP! vba excel chart generation

[The_Undertaker]

---

Mga bro!

I am currently working on a large workbook with several sheets and lots of charts in every sheets. My problem it when i execute this code:

ActiveChart.Location Where:=xlLocationAsObject, Name:=worksheet_name & " (Chart)"

vba gives off an error 5 "Invalid procedure call or argument". I don't understand how this could be when the same sequence of code works fine with the other sheets except to one. I thought having too many charts may had triggerd this error so i tried deleting all other charts and try the codes again, but still the same error. I tried looking into the DATA TABLE and i couldnt find anything anusual about it. Exactly the same design as the other sheets still. The code above is under a do-while loop (if you should know). My gues is that the error may be somewhere else and not the code above but how come it works fine with other sheets?

Pls do help mga bro... im using the MS office 2003 version and later to be move to MS Office 2007.

[The_Undertaker]

up lang PO.... urgent man gud mga bro... hehehehe

[gamberro]

ActiveSheet.ChartObjects("Chart 3").Activate
ActiveChart.ChartArea.Select
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range(Cells(6, 1), Cells(9, aCol)), PlotBy:= _
xlRows


Try this sample code. I hope it could be help.