Been trying to figure out what the reason caused the "Invalid Parameter" error for the past 20 minutes... and still clueless. Anyway, In my worksheet I have 2 charts. In my VBA code, I defined both chart with individual seriescollection (SeriesCollection(1) for chart one and SeriesCollect(2) for chart two). However, I kept getting the Invalid Parameter at line ChtObjTELCO.Chart.SeriesCollection(2).Values = Range(Cells(UserRow, 8), Cells(UserRow, 9)) and to be honest, I can't figure it out why.
Any help is appreciated.
Below is my code and I have attached a sample workbook
Bookmarks