Question: Need help writing VBA code for the following. 1) Write a function named areEqual. It should accept two arrays of type Single , both of

Need help writing VBA code for the following.

1) Write a function named areEqual. It should accept two arrays of type Single, both of the same size, and it should return a boolean value indicating whether the two arrays are equal or not. It should return True if they are equal and False otherwise. For example, if you pass in the arrays (3,5,1) and (4,3,6) it should return False and the program should display a message indicating that two arrays are not equal.

2) Write a subroutine named TestMyFunctions that declares the two arrays you can hardcode the values in) and calls your arrayEqual function and displays the results. Write the results out to a worksheet cell. Your function should test that the two arrays have the same number of elements.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

write the code in C language 1. Write a function named SplitAndSummarize that receives three different (2D) two dimensional arrays all of type integer. The received arrays are of the following sizes:...

1. Write a function that takes three values as arguments. It should appends the first two characters in the first string, the middle three characters of the second string, and the last two characters...

Hello all. So I'm new to C++ and I've spent 3 days trying to make the code below compile!! If anyone can help me fix it, I'll be extrmrely thankful as the final code is due tonight. Thank you!...

C++ OUTPUT MUST BE EXACT Assignment 3.1 [40 points] This assignment will give you a chance to perform some simple tasks with pointers. The instructions below are a sequence of tasks that are only...

This assignment will give you a chance to perform some simple tasks with pointers. The instructions below are a sequence of tasks that are only loosely related to each other. Start the assignment by...

Follow these detailed instructions: First, read this document in its entirety. Include the usual (detailed) comment block including program name, author, date, inputs, outputs and description,...

This is a two-part assignment which includes Pointer Tasks, and The League with DMA. 1. Pointer Tasks This part of the assignment will give you a chance to perform some simple tasks with pointers....

Follow these detailed instructions: First, read this document in its entirety. Include the usual (detailed) comment block including program name, author, date, inputs, outputs and description,...

Complete the following steps in a single code cell: 1 . Read the contents of the data file into and RDD named pairs _ raw. 2 . Display the number of elements contained in the pairs _ raw RDD We will...

Use the following information to answer the questions: Assets Liabilities and Equity Cash 10,000 Accounts payable 17,000 Marketable securities 2,000 Notes payable 6,000 Accounts receivable 3,000...

Cunningham Company reports a retained earnings balance of $365,200 at the beginning of 2007. For the year ended December 31, 2007, the company reports pretax income from continuing operations of...

Job-Order Cost Sheets, Balance in Work in Process and Finished Goods Prull Company, a job-order costing firm, worked on three jobs in July. Data are as follows: Overhead is applied to jobs at the...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

KEY QUESTION Explain the following statement, using the MB curve in Figure 28.6 to illustrate: The optimal amount of pollution abatement for some substances, say, water from storm drains, is very...

KEY QUESTION Suppose there are only five people in a society and each favors one of the five highway construction options in Table 28.2 (include no highway construction as one of the options)....

Explain how affirmative and negative majority votes can sometimes lead to inefficient allocations of resources to public goods. Is this problem likely to be greater under a benefits-received or under...