lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I created macros by recording my steps. macros to create table, fill table, change color of the sheet, clear the sheet and drawing a chart. I assigned buttons to these macros and they all working except the Chart one. When click on Chart button I get run time error but if i clicked on End then excel will draw the chart for me anyway. Why is that. Any help would be appreciate.
Here is my file
https://drive.google.com/file/d/1BTR0bzZEp-U5l_zuWVrgFLF_2DcpiDi1/view?usp=sharing
I created macros by recording my steps. macros to create table, fill table, change color of the sheet, clear the sheet and drawing a chart. I assigned buttons to these macros and they all working except the Chart one. When click on Chart button I get run time error but if i clicked on End then excel will draw the chart for me anyway. Why is that. Any help would be appreciate.
Here is my file
https://drive.google.com/file/d/1BTR0bzZEp-U5l_zuWVrgFLF_2DcpiDi1/view?usp=sharing
