Determine the number of rows and column of data on worksheet

Assignment Help Computer Engineering

Reference no: EM131986634

Problem

A user (me) inputs values of an MxN matrix starting at cell A1 in Sheet2. Create a run button on Sheet2 that executes a macro named problem2.
This macro solves the following problem:

• Determine the number of rows and columns of data on the worksheet and store these values in variables named M and N.

• Create a MxN array named array1.

• Obtain the values from the worksheet and store them in array1.

• Calculate the transpose of array1 and output the transpose one row below the original MxN array. For example, if the user inputs the following array, the macro will calculate the transpose after the run button is clicked and output it to the worksheet, This macro should work for any MxN array input by the user. Hint: You can check if there is only one row or one column by checking if ActiveCell.Value = "" for cells A2 and B1. Do not use the built-in Excel function Transpose. Use the Option Explicit statement for this macro. Assume the user will input all necessary values on the worksheet before clicking the run button.

Reference no: EM131986634

Questions Cloud

Quality improvement part of qm : Define quality management (QM). Explain how quality assurance (QA) and quality improvement (QI) are part of QM.

Can you think of a situation where you also have access : For a small business, having payment terms is like using "free money" for a while. What do you think this means?

Define quality assurance and quality improvement : Define quality assurance (QA) and quality improvement (QI). Give an example of how each applies to healthcare. Describe the differences between the two.

Best possible outcomes for the provider : How can we create the alignment of incentives that creates the best possible outcomes for the provider, supplier and the patient?

Determine the number of rows and column of data on worksheet : Determine the number of rows and columns of data on the worksheet and store these values in variables named M and N. Create a MxN array named array1.

How do the assessment core function : How do the assessment core function, organizational practices, essential public services, and performance indicators interrelate?

By how much will the companys value increase : If the company chooses the machine which adds the most value to the firm, by how much will the company's value increase?

Case study-managing gi discomfort : Mary Treat is a 68-year-old woman in reasonably good health. She is 64 inches tall and weighs 180 pounds. She takes a daily multi-vitamin supplement

What is the market price of a face value bond : Slan, Inc. Offers a 7 percent coupon bond with annual payments. The yield to maturity is 5.85 percent and the maturity date is 9 years.

User Account

All Pages