Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is wrong with this Macro? I keep on getting Run-time error '1004'. It was an exceedingly simply macro, and I was trying to create
What is wrong with this Macro? I keep on getting Run-time error '1004'. It was an exceedingly simply macro, and I was trying to create a graph from some data, but it quite simply will not work. It has an issue with the line of code highlighted:
Sub Macro 1() Macro Macro Active Cell FormulaR1C1 month Range ("B4").Select ActiveCell. FormulaR1C1 Jan Range ("B5").Select ActiveCell. FormulaR1C1 feb Range ("B4 B5"). Select Selection. AutoFill Destination: Range ("B4:B15"), Type FillDefault Range ("B4 B15").Select Range ("C3").Select ActiveCell. FormulaR1C1 temp Range ("C4") .Select ActiveCell. FormulaR1C1 22 Range ("C5") Select Active Cell FormulaR1C1 33 Range ("C6") Select Active Cell. FormulaR1C1 44 Range ("C7").Select ActiveCell. FormulaR1C1 55 Range ("C4 C7"). Select Selection. AutoFill Destination: Range ("C4: C15"), Type FillDefault Range ("C4 C15'').Select Range ("B3: C15").Select ExecuteExcel4Macro (FALSE, 227, 65) ActiveChart.SetSourceData Source: Range ("Sheet1!$B$3:$C$15") Range ("E27") .Select Sheets. Add End SubStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started