VBA Excel error (Specified dimension is not valid for the current chart type)

[exile303]

Hi, may i ask a question?

i have recently been checking on codes on windows 7 excel, and found it that it could be run well on windows 7.
but not on windows 8.

whenever i run on windows 8 i receive such error prompt
"Specified dimension is not valid for the current chart type"


dim sheetno as integer
sheetno = sheetno + 1

If sample_namber >= 4 Then
NewWork3.Sheets.Add After:=NewWork3.Sheets(NewWork3.Sheets.count)
End If

--> Set NewSheet3 = NewWork3.Worksheets(sheetno)

above code where arrow indicates where the error comes from.

may i ask if there is any solution to this?
Thank you in advance.

 

[exile303]

to update with,
it is working fine on excel 2010, but error is prompted on excel 2013