Hwan created a macro named CopyStats to copy the project statistics in the range I3:L22, and then paste them on a new worksheet. When he runs the CopyStats macro, however, it includes extra data from column G. View and edit the macro as follows:Open the CopyStats macro in the Visual Basic Editor. The macro should select and copy the range I3:L22.In the CopyStats macro VBA code, change the range specified in the first line of code after the comments (Range("G3:L22").Select) to use I3:L22 as the range.Save and close the CopyStats macro.Run the CopyStats macro.Use Project Stats as the name of the new worksheet the macro created.

Initially, we used G3:L22 to generate random values.

Answered: Hwan created a macro named CopyStats to…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

100%

Hwan created a macro named CopyStats to copy the project statistics in the range I3:L22, and then paste them on a new worksheet. When he runs the CopyStats macro, however, it includes extra data from column G. View and edit the macro as follows:
1. Open the CopyStats macro in the Visual Basic Editor. The macro should select and copy the range I3:L22.
2. In the CopyStats macro VBA code, change the range specified in the first line of code after the comments (Range("G3:L22").Select) to use I3:L22 as the range.
3. Save and close the CopyStats macro.
4. Run the CopyStats macro.
5. Use Project Stats as the name of the new worksheet the macro created.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions