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, 22.06.2019 23:40
Joint cost cheyenne, inc. produces three products from a common input. the joint costs for a typical quarter follow: direct materials $45,000 direct labor 55,000 overhead 60,000 the revenues from each product are as follows: product a $75,000 product b 80,000 product c 30,000 management is considering processing product a beyond the split-off point, which would increase the sales value of product a to $116,000. however, to process product a further means that the company must rent some special equipment costing $17,500 per quarter. additional materials and labor also needed would cost $12,650 per quarter. a. what is the gross profit currently being earned by the three products for one quarter? $answer b. what is the effect on quarterly profits if the company decides to process product a further? $answer
Answers: 2
question
Business, 23.06.2019 02:00
Andrea's opportunity cost rate is 12 percent compounded annually. how much must he deposit in an account today if he wants to receive $2,100 at the beginning of each of the next seven years? use the equation method to determine the amount.
Answers: 3
question
Business, 23.06.2019 09:50
Frick (1991) claimed that computers would become so powerful that k-12 educators and students would be able to produce their own multimedia and web-based learning materials. he predicted that teachers and students would soon be able to use computer-video technology to produce their own learning materials. all it would require is time, know-how, and some funds.
Answers: 3
question
Business, 23.06.2019 13:50
In ledland, unemployed adults receive government assistance. to reduce unemployment, the government proposes to supplement the income of those who accept jobs that pay less than government assistance, thus enabling employers to hire workers cheaply. however, the supplement will not raise any worker's income above what government assistance would provide if he or she were not gainfully employed. therefore, unemployed people will have no financial incentive to accept jobs that would entitle them to the supplement.which of the following, if true about ledland, most seriously weakens the argument of the editorial? (a) the government collects no taxes on assistance it provides to unemployed individuals and their families.(b) neighboring countries with laws that mandate the minimum wage an employer must pay an employee have higher unemployment rates than ledland currently has.(c) people who are employed and look for a new job tend to get higher-paying jobs than job seekers who are unemployed.(d) the yearly amount unemployed people receive from government assistance is less than the yearly income that the government defines as the poverty level.(e) people sometimes accept jobs that pay relatively little simply because they enjoy the work.
Answers: 3
You know the right answer?
Elias recorded a macro for formatting all of his data cells that include scientific number notation....
Questions
question
English, 06.08.2019 02:10
question
Mathematics, 06.08.2019 02:10
Questions on the website: 13722359