Question: 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:

What is wrong with this Macro? I keep on getting Run-time error

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I am recording a simple macro that creates a data graph using two columns. When I run the macro code I keep getting the following error: Run-time error '1004': The formula you typed contains an...

Hey I need help with this lab, this is our first lab and I don't know how to make it. This is not a big lab just a lot of explanations, thank you! Ch. 16 Lab This lab requires you to use the...

Step 1: Tasks 1.1 ? 1.6 For each of the above accounts under the first tab (Type/description) examine the entries in the Control in chart of accounts box including the Account group and radio button...

Business Event Analysis: Complete the following table based on the specified NBD event. Receive Shipment (From Supplier) Trigger(s) (also indicate type) Collected Data (originates as input for event)...

1) Read the "Cybersecurity: the three-headed Janus" case posted under Module 2. Provide a summary of the vulnerabilities of Randcom's current information systems. Make sure to address each...

Please read the question Question: What is the main points discussed and write a 1-2 paragraph summary on what is your opinion. Make sure to include a a brief description of replication and why it is...

Due to the changing environment and external triggers, contingency planning is necessary. What qualities make a future issue a ?trigger?? Consider you are on the strategic planning team for a soft...

Through the use of strategic alternatives, companies may compete in a marketplace, achieve its vision, or if no vision has been articulated, decide where it might go and what it might achieve....

1. Read the articleSix Impossible Things Before Breakfast. Is the Efficient Market Hypothesis (EMH) the correct theory relative well functioning financial markets? If not why not? 2.Read the...

Module Case Study Information A Module Case Study is a critical analysis and evaluation of a specific case or subject. For this course a Module Case Study must: Be two pages in length, double-spaced....

When bears were anesthetized, researchers measured the distances (in inches) around their chests and they weighed the bears (in pounds). The results are given below for 8 male bears. Based on the...

A room contains 75 kg of air at 100 kPa and 15C. The room has a 250-W refrigerator (the refrigerator consumes 250 W of electricity when running), a 120-W TV, a 1.8-kW electric resistance heater, and...

For tax purposes, which of the following depreciation methods may be used for a property with a 1 5 - year recovery period? A ) 2 0 0 % declining balance switching to straight line B ) 1 5 0 %...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

3. Incorporate adult learning theory into the design of a training program.

5. Discuss the internal conditions (within the learner) and external conditions (learning environment) necessary for the trainee to learn each type of capability.

2. Encourage trainees to develop a strategy (metacognition) to reflect on their own learning process. Metacognition refers to individual control over ones thinking. Two ways that individuals engage...