subject
Business, 17.05.2021 18:00 krlx

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?

Using the VBA editor, he could find every instance of “VerticalAlignment,” and then change the text after the equal sign from “xlBottom” to “xlTop.”
Using the VBA editor, he could find every instance of “HorizontalAlignment,” and then change the text after the equal sign from “xlBottom” to “xlTop.”
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.
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: 2

Another question on Business

question
Business, 21.06.2019 23:10
You are the new chief information officer for the video-game developer, necturus games. the company has recently undergone a major expansion of its primary product, and you must staff up the is department and determine the best way to develop new game "capsules" for the game, "escape velocity."
Answers: 1
question
Business, 22.06.2019 19:30
About 20 years ago, sturdy light, inc., produced a sturdy, lightweight backpack in a market that was rapidly growing. sturdy light became a leader in this market. eventually, the backpack market reached the maturity stage and slowed down. however, by this time, sturdy light had developed a strong brand name and continued to steadily lead the market. which of the following describes this scenario? a. sturdy light was a star that developed into a cash cow. b. sturdy light was a question mark that developed into a star. c. sturdy light was a dog that developed into a question mark. d. sturdy light was a cash cow that developed into a star.
Answers: 2
question
Business, 22.06.2019 22:30
Using the smith's bbq report, the cost of wine for next week will increase by 2% from the current week. if all other cost of sales stays constant, what will be the approximate total cost of sales for next week?
Answers: 2
question
Business, 23.06.2019 00:00
The gorman group is a financial planning services firm owned and operated by nicole gorman. as of october 31, 2016, the end of the fiscal year, the accountant for the gorman group prepared an end-of-period spreadsheet, part of which follows:
Answers: 2
You know the right answer?
Elias recorded a macro for formatting all of his data cells that include scientific number notation....
Questions
question
History, 07.04.2020 18:42
Questions on the website: 13722359