How the proper information is placed for each person

Assignment Help JAVA Programming
Reference no: EM13950634

I have an assignment due and am having issues with the first part (which is needed to do all of the other parts). I have the following VBA code written:
Private Sub DisplayData(strArray() As String)
Dim intFriend As Integer
For intFriend = 1 To mintNumFriends
Cells(intFriend + 1, 1).Value = strArray(1)
Cells(intFriend + 1, 2).Value = strArray(5)
Cells(intFriend + 1, 3).Value = strArray(6)
Cells(intFriend + 1, 6).Value = strArray(4)
Cells(intFriend + 1, 5).Value = strArray(3)
Cells(intFriend + 1, 4).Value = strArray(2)
Next intFriend

I understand how this works, but I don't know what numbers should be placed into the () for the strArray. The numbers coordinate with 6 pieces of personal information for intFriend 1. They are placed in A2-F2. My problem is that I have no idea how to change this information to apply to all the other friends (the current formula repeats friend 1's information for all the others). For example, friend 2's information involves Arrays 8-13, and friend 3's involes 15-20.
My question is, in a nutshell, what should I place in the () for strArray so that the proper information is placed for each person?
All help is greatly appreciated!

Reference no: EM13950634

Questions Cloud

Case - numbness and pain : Case: Numbness and Pain, A 47-year-old obese female complains of pain in her right wrist, with tingling and numbness in the thumb and index and middle fingers for the past 2 weeks. She has been frustrated because the pain causes her to drop her ha..
Manufactures bamboo picture frames : manufactures bamboo picture frames that sell for $35 each. Each frame requires 4 linear feet of bamboo, which costs $3.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $14.00 per hour. Iguana has the follow..
Pros or cons when monetary discipline in countries : When reflecting on the IMF/World Bank and the Mexican Currency crisis of 1995, as a global manager, how do you believe the IMF can play a part in either crisis?
Rate of entropy production : Determine (a) the velocity at the nozzle exit, in ft/s, (b) the isentropic nozzle efficiency, and (c) the rate of entropy production within the nozzle, in Btu/8R per lb of helium flowing.
How the proper information is placed for each person : My question is, in a nutshell, what should I place in the () for strArray so that the proper information is placed for each person
Prepare a consolidated worksheet for december : Using the vertical format, prepare a consolidated worksheet for December 31, 20X2. Precede the worksheet with a value analysis and a determination and distribution of excess schedule.
Motivation in the jack welch icon of leadership : "Motivation" in the Jack Welch Icon of Leadership video, describe what intrinsic/extrinsic motivators do you see applied within your organization
Assume the existence of a function copyvillian : Show how you would use the above copyVillian function to create a copy of sharpay called sharpaysMoreEvilTwin.
Encourage competition and collaboration to motivate : How you encourage competition and collaboration to motivate your workforce. Must be 2 full pages and limit the words of "ly" APA format

Reviews

Write a Review

JAVA Programming Questions & Answers

  E-marketing-e-commerce consultant

You are an e-marketing and e-commerce consultant. Mary and Joe Johnson, the owners of Book Bunker, have hired you to help them improve their sales both online and in their store.

  Circuit for nuclear power plant alarm

Design a circuit for nuclear power plant alarm (slide #2) . Construct a) truth table, b) Boolean expression, c) draw logic circuit, and d) simulate with Multisim (or equivalent) circuit simulation software. Clearly label all inputs and outputs.

  Allow the user to display a work history report

The 'report screen' shall:Allow the user to display a work history report for an individual or for all employees for the two weeks prior to the report request.

  This is a client server monitoring system project

this is a client server monitoring system project design.first in the server side the 1a program is my own and i have

  Java application that asks a user to enter two integers

Write a Java application that asks a user to enter two integers (A and B) and then display the results of A/B. Catch any division by zero errors and prompt the user to reenter the value of B. Be sure your code compiles and runs as expected. Name your..

  The desired functionality is for your programs to input

the desired functionality is for your programs to input pairs of natural numbers as theyre entered by the user until

  Screenshots for actual output after testing

Coversheet Title page (including acknowledgements) Table of contents Design Include the algorithm and class diagram of your code under this section 5. Testing Use the table given below to provide your test data. Include screenshots for actual outp..

  Once getting into student information menu

Once getting into student information menu, you should be able to see a full list of students' information (first name, last name, SSN, DOB, year and major).

  Determine if strings are equal

Complete the recursive method match in the code below which will determine whether or not two strings match.

  Modeling the caves

Assignment 2 Description:  You are a mighty warrior, and armed with your trusty bow and 3 arrows, you enter The Caves in search of the mighty Wumpus. If you shoot the Wumpus, you are victorious and the masses will praise you, but if you stumble upon ..

  Prepare a java application will read the database file

Prepare a java application will read the database file. The path of the database file will be supplied by a run-time parameter. If the database file does not exist, the user will be told the database does not exist.

  Find the appropriate bucket

Modify Entry to include the extra field for the next reference. The method findIndex will need to utilize a hash value to find the appropriate bucket. Methods bucketGet and bucketPut will need to walk through the list as necessary looking for a ke..

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