subject

Elias recorded a macro for formatting all of his data cells that include scientific number notation. After recording a long series of steps, he practices running the macro. Then he realizes that he meant to make all of these cells top-aligned instead of the default bottom-aligned. What is the most efficient way for Elias to fix this macro?

A. Using the VBA editor, he could find every instance of “VerticalAlignment,” and then change the text after the equal sign from “xlBottom” to “xlTop.”

B. Using the VBA editor, he could find every instance of “HorizontalAlignment,” and then change the text after the equal sign from “xlBottom” to “xlTop.”

C. He could record the macro again, type in “xlBottom” to deactivate the default setting, and then select the top-align button under the Home tab.

D. He could record the macro again, select the bottom-align button under the Home tab to deactivate it, and then type in “xlTop” to trigger the correct setting.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 03:30
Identify at least three types of characteristics that you were asked about as you the computer identify a fruit.
Answers: 3
question
Computers and Technology, 22.06.2019 14:40
You begin your first day of responsibilities by examining the recent is security breach at gearup to get ideas for safeguards you will take. at gearup, criminals accessed the company's improperly-secured wireless system and stole customers' credit card information as well as employee social security numbers. what kind of computer crime did gearup face?
Answers: 3
question
Computers and Technology, 22.06.2019 22:00
What is a distinguishing feature of today’s graphic application software?) graphic applications are used today on a variety of devices, including touch-screen kiosks and mobile phones.
Answers: 3
question
Computers and Technology, 23.06.2019 06:10
The head restraint should be adjusted so that it reaches a.the top of your ears b.the base of your skull c.the top of the head
Answers: 1
You know the right answer?
Elias recorded a macro for formatting all of his data cells that include scientific number notation....
Questions
question
Mathematics, 26.06.2019 07:30
Questions on the website: 13722360