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.

Reviews

Write a Review

Computer Engineering Questions & Answers

  Recognizing the error

Make out error in the following given code:#include //Line 1 using namespace std; //Line 2

  What is the value of the minimal average latency

List all greedy cycles from the state diagram. What is the value of the minimal average latency? What is the maximal throughput of this pipeline?

  Which is a proper use of naming convention for a control

Which of the following is a proper use of naming convention for a control? Allow the user to hit the Enter key by setting a default button on the form using the property?

  Write the xhtml for unordered list to display days of week

Write the XHTML to display your name in the largest size heading element. Write the XHTML for an unordered list to display the days of the week.

  What is the minimum number of chopsticks deadlock freedom

Consider the variation of the Dining Philosophers problem shown in Figure where all unused chopsticks are placed in the center of the table and any philosoper.

  Make a class called invoice that a hardware store might use

create a class called invoice that a hardware store may use to represent an invoice for an item sold at the store. the

  Security devices for protection against different attack

Describe two or more attacks for which the routers (layer 3 devices) are vulnerable. Explain how these attacks are detected and prevented by the security devices.

  The open systems interconnect osi model is a conceptual

the open systems interconnect osi model is a conceptual model that characterizes and standardizes the internal

  Write a driver program to test all your methods

Give the definition of a class named Doctor whose objects are records for a clinic's doctors. Write a driver program to test all your methods.

  What are the components of a communication protocol

What are the components of a communication protocol? Describe frequency modulation, amplitude modulation, phase-shift modulation, and on-off keying.

  Calculate the overall sentiment value for each topic

CS 2034 Data Analytics: Principles and Tools - Determine the total number of Positive, Negative, and Neutral Tweets in the dataset

  Which skills are employers seeking

Beyond the technical skills your degree does/will provide, what other skills are employers seeking? Have a look at job advertisments such as those in CareerOne. Other than technical skills, which skills are employers seeking?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd