Why proper information is placed for each person

Assignment Help Computer Engineering

Reference no: EM1335251

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: EM1335251

Questions Cloud

Define what a branch hazard is,what causes a branch hazard : Give a relevant example using the MIPS instruction set architecture. Compare and contrast how the code would proceed it the branch is taken, vs if the branch is not taken, and explain how this affects the pipeline.

Orientation strategies of international hrm : List and explain the four Orientation Strategies of International Human Resource Management with respect to staffing policy.

Illustrate factors combined to alter the context of european : Illustrate factors combined to alter the context of European economics development and how were they evident in the economic problems faced by European nations in the inter war period.

Adequacy of project policies-procedures and techniques : Demonstrate the adequacy of project policies, procedures, and techniques.

Why proper information is placed for each person : 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 instance , friend 2's information involves Ar..

Prepare a financial analysis on any organization : Prepare a financial analysis on any organization.

Manager''s department or organization : What can a manager do, working with human resources, to redress problems of internal equity that may cause an exodus of personnel from the manager's department or organization?

Elucidate assumption concerning economies of scale : Elucidate assumption concerning economies of scale will give rise to a determinant and optimal scale of the firm in Long run equilibrium in perfect competetion.

Launch new brands in an effort to increase their profits : In the presence of excess capacity, firms sometimes launch new brands in an effort to increase their profits. Why would a monopolist not launch a new brand?

User Account

All Pages