Question: Can you help me with this excel vba code ? Develop a VBA sub FindFives that will return the array row numbers and array column

Can you help me with this excel vba code ? Develop a VBA sub FindFives that will return the array row numbers and

Can you help me with this excel vba code ?

Develop a VBA sub FindFives that will return the array row numbers and array column numbers of all 5's that are encountered in a user-defined selection. Row and column numbers should be ouput nicely starting in cell E2 (for row indices) and F2 (for column indices). If there are no matches, there should be a message box indicating so. Make sure there is a button on the sheet to run your sub (selection must be selected before running the sub). The file "BuildArray.xlsm on D2L will help you, especially with respect to the ReDim Preserve statements (which allows the vector to be resized while keeping all existing elements) See the flowchart on the following page. It has everything on it except you will need to figure out how to display "No Fives Found if there are no 5's in the selection Develop a VBA sub FindFives that will return the array row numbers and array column numbers of all 5's that are encountered in a user-defined selection. Row and column numbers should be ouput nicely starting in cell E2 (for row indices) and F2 (for column indices). If there are no matches, there should be a message box indicating so. Make sure there is a button on the sheet to run your sub (selection must be selected before running the sub). The file "BuildArray.xlsm on D2L will help you, especially with respect to the ReDim Preserve statements (which allows the vector to be resized while keeping all existing elements) See the flowchart on the following page. It has everything on it except you will need to figure out how to display "No Fives Found if there are no 5's in the selection

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!

Add Excel VBA code to create three new columns to the existing code listed below. Add Standard deviation for X army in Column, add Standard deviation for Y army in Column K, add Number of runs in...

Task : Simulate the growth of a biological population. The Game of Life , invented by John H. Conway, is supposed to model the genetic laws for birth, survival, and death. Our implementation of the...

Exam 3-Scaling Up with VBA Learning Objective: In this assignment, you will use your recently acquired knowledge of Excel VBA coding to scale up the analysis from the previous exercise. You should be...

help me Excel_Comprehensive_Capstonel_Wint ect Description: s project, you will apply skills you practiced from the objectives in Excel Chapters 4 through 10. You will develop a book for Frank Osei,...

1. (6 points) Create a user-defined function called Hexagon that takes one argument called side and returns the area of a regular hexagon given the length of the side. Show that the function works in...

In C++ Project requires code to be executable. Base Code is included at the bottom for your convenience. Base Code for your convenience: You will write an nxn tic-tac-toe game/program that utilizes...

In C++! Project requires code to be executable. Base Code is included at the bottom for your convenience. Base Code for your convenience: You will write an nxn tic-tac-toe game/program that utilizes...

Project requires code to be executable. Base Code is included at the bottom for your convenience. Code in C++. Base Code for your convenience: You will write an nxn tic-tac-toe game/program that...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

A 98.2-g aluminum calorimeter contains 258 g of water. The aluminum and water are initially in thermal equilibrium at a temperature of 11C. Two solid objects are then placed in the water. One is a...

Center Company acquired three intangible assets before 2021. The entity is preparing financial statements on December 31, 2021. Before that date, no formal financial statements had been prepared and...

Which of the following statements about credit analysts' models is true? Muriple Choice Credt analysts rarely use comprehensive arrual financial reports Credt anslyts focus primarily on demographic...

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...

4. Fantasy analogy. What is your wildest fantasy about how to solve this problem? How would solving the problem change the future? What is the best possible outcome?

How might you build a more balanced and healthy repertoire of coping skills?

3. Where and how would you begin to work toward getting such an innovation implemented? What factors do you think will support its adoption? What might be the significant barriers?