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 02:20
The following information is available for jase company: market price per share of common stock $25.00 earnings per share on common stock $1.25 which of the following statements is correct? a. the price-earnings ratio is 20 and a share of common stock was selling for 20 times the amount of earnings per share at the end of the year. b. the market price per share and the earnings per share are not statistically related to each other. c. the price-earnings ratio is 5% and a share of common stock was selling for 5% more than the amount of earnings per share at the end of the year. d. the price-earnings ratio is 10 and a share of common stock was selling for 125 times the amount of earnings per share at the end of the year.
Answers: 1
question
Business, 22.06.2019 10:30
Issued to the joint planning and execution community (jpec) initiates the development of coas; it also requests that the supported ccdr submit a commander's estimate of the situation with a recommended coa to resolve the situation (joint force command and staff participation in the joint operation planning and execution system, page 10)
Answers: 2
question
Business, 22.06.2019 12:00
Which of the following is one of the advantages primarily associated with a performance appraisal? (a) it protects employees against discrimination on the basis of race. (b) it motivates employees to work on their shortcomings. (c) it encourages employees to play the role of the whistle-blower. (d) it accurately measures the resources of the firm.
Answers: 2
question
Business, 22.06.2019 13:00
Dakota products has a production budget as follows: may, 16,000 units; june, 19,000 units; and july, 24,000 units. each unit requires 3 pounds of raw material and 2 direct labor hours. dakota desires to keep an inventory of 10% of the next month’s requirements on hand. on may, 1 there were 4,800 pounds of raw material in inventory. direct labor hours required in may would be:
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, 08.04.2020 00:49
question
Mathematics, 08.04.2020 00:49
Questions on the website: 13722367