Question: On a new sheet called Hello, insert numbers into the range A1:E10. The following code is used to format some data. This code works perfectly

On a new sheet called Hello, insert numbers into the range A1:E10. The following code is used to format some data. This code works perfectly well, but it is quite repetitive. Rewrite it by using as many with constructions as make sense. Using appropriate indentation and then run your modified code to make sure it still works. Sub FormatARange() ActiveWorkbook.Worksheets("Hello").Range("B1").Font.Bold = True ActiveWorkbook.Worksheets("Hello").Range("B1").Font.Size = 14 ActiveWorkbook.Worksheets("Hello").Range("B1").Interior.Color = vbYellow ActiveWorkbook.Worksheets("Hello").Range("B1").HorizontalAlignment = xlLeft ActiveWorkbook.Worksheets("Hello").Range("A3:A8").Font.Bold = True ActiveWorkbook.Worksheets("Hello").Range("A3:A8").Font.Italic = True ActiveWorkbook.Worksheets("Hello").Range("A3:A8").Interior.Color = vbGreen ActiveWorkbook.Worksheets("Hello").Range("A3:A8").InsertIndent 1 ActiveWorkbook.Worksheets("Hello").Range("B2:E2").Font.Bold = True ActiveWorkbook.Worksheets("Hello").Range("B2:E2").Font.Italic = True ActiveWorkbook.Worksheets("Hello").Range("B2:E2").Font.Color = vbYellow ActiveWorkbook.Worksheets("Hello").Range("B2:E2").Interior.Color = vbBlue ActiveWorkbook.Worksheets("Hello").Range("B2:E2").HorizontalAlignment = xlRight ActiveWorkbook.Worksheets("Hello").Range("B3:E8").Interior.Color = vbRed ActiveWorkbook.Worksheets("Hello").Range("B3:E8").NumberFormat = "$#,##0"

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 General Management Questions!

1. (6 points) Create a user-defined function called Hexagon that takes one argument called side and returns the area of a regular hexagon given the length of the side. Show that the function works in...

4. (5 points) Start with a clean version of the file Training.xlsx. Write a VBA sub that sorts the scores in descending order on exam 1. Break ties by sorting in ascending order on exam 2. OVER 5. (5...

DATA STRUCTURE...please help In this question, you will be implementing a hash table with a set of functionalities specified below. As you know, we already covered this topic in class and even...

Data Structure In this question, you will be implementing a hash table with a set of functionalities specified below. As you know, we already covered this topic in class and even provided an...

Python. need urgent Using the implementation of a binary tree node class named bt_node provided for you below, you will implement a number of methods for a class called complete_binary_tree, which...

Using the implementation of a binary tree node class named bt_node provided for you below, you will implement a number of methods for a class called complete_binary_tree , which represents a complete...

s1 educated (SSE) student for every three public school educated (PSE) students. Reasoning that students are not very dissimilar from threads, he suggests the following entry and exit routines be...

I have to create a program in C and I can't figure it out. The program has to read a source file. Please help. /******************************************************************** PROJECT: Glossary...

Language is C Please read and follow instructions carefully. This is the existing code where the above functions need to be implemented. I have already implemented the functions mentioned in this...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

Data on the physical inventory of Timberline Co. as of December 31, 2006, are presented in the working papers. The quantity of each commodity on hand has been determined and recorded on the inventory...

Evaluate the claim that stagflation is anathema to the Phillips Curve. The indication is that inflationary expectations have become entrenched and strongly footed in world markets. As a result, the...

FIN 4 4 7 - Final Exam ( Spring 2 0 . . . Help Sove 8 Exit Submit investor purchases shares of an index fund. The investor could take on the same level of risk by taking out a loan and purchasing a...

While reviewing a new audit case, you realize the tax return belongs to your sister's ex-boyfriend.You also notice several possible discrepancies on the tax return that need further examination. Your...