Home

MS Excel 2013 Macros Failure

Monica Bossert
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
Highlighted
If you click OK on that dialog, which line turns blue?
Highlighted

Capture.JPG

Highlighted
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.
Related Conversations
DAX Powerpivot - How to solve this problem in PowerPivot
kayyeah11 in Excel on
0 Replies
IF statements and conditional formatting
clare1981 in Excel on
1 Replies
Reverse numbers and characters in worksheet
David_Gerrior in Excel on
1 Replies
Sumifs
Jsbluemoon82 in Excel on
4 Replies
Excel formula similiar to texjoin
Carlo74 in Excel on
1 Replies
everything is black and white in excel
Gold4trees in Excel on
2 Replies