MS Excel 2013 Macros Failure

Brass Contributor

Hello,

 

I recorded a Macros on one tab to create 6 charts from data available on that sheet, but when I added the macros to the next sheet, it fails and gives me the below message

 

Failed Macros.png

 

Any help would be greatly appreciated. Thanks!

3 Replies
If you click OK on that dialog, which line turns blue?

Capture.JPG

The compile error means something is missing, in this case a range of cells. Like in the line immediately above the one with the error.