subject
Business, 09.04.2021 23:10 naenae1405

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, 22.06.2019 05:10
1. the political environment in india has proven to be critical to company performance for both pepsico and coca-cola india. what specific aspects of the political environment have played key roles? could these effects have been anticipated prior to market entry? if not, could developments in the political arena have been handled better by each company? 2. timing of entry into the indian market brought different results for pepsico and coca-cola india. what benefits or disadvantages accrued as a result of earlier or later market entry? 3. the indian market is enormous in terms of population and geography. how have the two companies responded to the sheer scale of operations in india in terms of product policies, promotional activities, pricing policies, and distribution arrangements? 4. “global localization” (glocalization) is a policy that both companies have implemented successfully. give examples for each company from the case.
Answers: 1
question
Business, 22.06.2019 11:10
Which of the following is an example of a production quota? a. the government sets an upper limit on the quantity that each dairy farmer can produce. b. the government sets a price floor in the market for dairy products. c. the government sets a lower limit on the quantity that each dairy farmer can produce. d. the government guarantees to buy a specified quantity of dairy products from farmers.
Answers: 2
question
Business, 22.06.2019 12:20
Selected transactions of the carolina company are listed below. classify each transaction as either an operating activity, an investing activity, a financing activity, or a noncash activity. 1. common stock is sold for cash above par value. 2. bonds payable are issued for cash at a discount
Answers: 2
question
Business, 22.06.2019 19:10
The stock of grommet corporation, a u.s. company, is publicly traded, with no single shareholder owning more than 5 percent of its outstanding stock. grommet owns 95 percent of the outstanding stock of staple inc., also a u.s. company. staple owns 100 percent of the outstanding stock of clip corporation, a canadian company. grommet and clip each own 50 percent of the outstanding stock of fastener inc., a u.s. company. grommet and staple each own 50 percent of the outstanding stock of binder corporation, a u.s. company. which of these corporations form an affiliated group eligible to file a consolidated tax return?
Answers: 3
You know the right answer?
Elias recorded a macro for formatting all of his data cells that include scientific number notation....
Questions
Questions on the website: 13722362