Error: the specified dimension is not valid for the current chart type

[raylauk]

I get the above error when running my macro on the Sheet8.Paste line. Any one know why. I can't figure it out. Any help is appreciated.


If IsNumeric(CellBD5) Then
MetricsCounter = CellBD5
Else
MetricsCounter = 0
End If
If (MetricsCounter < 8#) Then
Sheet8.Select
Sheet8.Range("AB27:AO27,AB28:AO28").Select
Sheet8.Paste
Sheet8.Range("X27:AA27,X28:AA28,AK15:AO15").ClearContents
End If
Else
Sheet8.Visible = False
End If

 

[Worf]

Hello and welcome to the Board
Can you post the entire code? What do you have in the clipboard when this section executes?

 

[raylauk]

There's to much code and it won't copy and paste But wen launch excel it asks me to "open" "save" or "save as". If I "save" and open or "save as" and open, I don't get the error and the code works. Is that a clue. Why does it only happen when I "open"?

 

[Worf]

Could you remove sensitive data from the workbook and upload it to a hosting site like Dropbox?

 

[raylauk]

The problem is, if I save the spread sheet and then open it, it doesn't get the error. Only when it's downloaded and open in the web site do I get the error. It says it's in compatibility mode because it's an xls spread sheet. I tried converting it to xlsm, but get the same error. Could it be an IE11 setting since it only happen in IE when it's downloading the spread sheet?

 

[Worf]

You don't get all functionality when opening it with IE, see the picture: