Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribed

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 Sub

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Management Systems Designing And Building Business Applications

Authors: Gerald V. Post

1st Edition

0072898933, 978-0072898934

More Books

Students also viewed these Databases questions

Question

15. Give examples of variations in contextual rules.

Answered: 1 week ago