AVBA marco has been created to workwith some values in cells A2 to A4 in the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
AVBA marco has been created to workwith some values in cells A2 to A4 in the following worksheet. 60 20 30 The code of the macro is shown below. Sub DoSomething() Dim Vara As Dim VarB As Dim Count As Integer Variable Type 1 Variable Type 2 VarB = e For Count = 2 To 4 Set Vara = Cells(Count, 1) VarB = VarB + VarA.Value Next Count VarB = VarB/ 3 MsgBox "The result is & VarB End Sub The macro will produce this message box: Microsoft Excel The result is 36.6666666666667 ок What should be the variable types of the two variables, VarA and VarB? You need to write the answers clearly in the boxes below. You only need to write the variable type in each answer. Variable Type 1 (i.e. VarA's Type) is Variable Tvne 2 ie VarR's Tvnelis AVBA marco has been created to workwith some values in cells A2 to A4 in the following worksheet. 60 20 30 The code of the macro is shown below. Sub DoSomething() Dim Vara As Dim VarB As Dim Count As Integer Variable Type 1 Variable Type 2 VarB = e For Count = 2 To 4 Set Vara = Cells(Count, 1) VarB = VarB + VarA.Value Next Count VarB = VarB/ 3 MsgBox "The result is & VarB End Sub The macro will produce this message box: Microsoft Excel The result is 36.6666666666667 ок What should be the variable types of the two variables, VarA and VarB? You need to write the answers clearly in the boxes below. You only need to write the variable type in each answer. Variable Type 1 (i.e. VarA's Type) is Variable Tvne 2 ie VarR's Tvnelis
Expert Answer:
Related Book For
Advanced Accounting
ISBN: 978-1259444951
13th edition
Authors: Joe Ben Hoyle, Thomas Schaefer, Timothy Doupni
Posted Date:
Students also viewed these programming questions
-
The Red and Blue partnership has been created to operate a law firm. The partners have been attempting to devise a fair system to allocate profits and losses. Red plans to work more billable hours...
-
The Ace and Deuce partnership has been created to operate a law firm. The partners are attempting to devise a fair system to allocate profits and losses. Ace plans to work more billable hours each...
-
The conceptual framework has been created to make accounting information useful. Instructions Indicate whether the following statements about the conceptual framework are true or false. If false,...
-
In Fig. P2.72 gate AB is circular. Find the moment of the hydrostatic force on this gate about axis A. Neglect atmospheric pressure.
-
In problems, the density of a rod is given. Find c so that the mass from 0 to c is equal to 1. Whenever possible find an exact solution. If this is not possible, find an approximation for c. (a) (x)...
-
A beam of light strikes mirror-1 and then mirror-2 in Fig. P.4.9. Determine angles θ r1 and θ r2 . Figure P.4.9 30 Mirror-1 Mirror-2 45
-
Defendants Jack and Claire Lein owned and lived on Willow Creek Farm from 1980 through 2004. The farm manager, Stewart, and his girlfriend, plaintiff Tambra Curtis, also lived on the farm during this...
-
Echeverria SA is an Argentinian manufacturing company whose total factory overhead costs fluctuate somewhat from year to year according to the number of machine-hours worked in its production...
-
18) A physician prescribes one 0.7 mg tablet of a medication to be taken twice a day for 15 days. How many total mcg of the medication will the patient have taken after 15 days?
-
Write a letter to the Smith's discussing the results of their tax return, remind them of any deduction substantiation rules they need to follow (receipts, mileage log, etc.), offer suggestions for...
-
"What systematic procedures or algorithms can be employed to ascertain all the prime factors of a provided numerical value?"
-
You have to pay 11.9% retail tax where you live and you are buying a $17.60 case to protect your phone, what number should you multiply the price of the case by, in order to get the total amount of...
-
Preston Partners, a calendar-year partnership, has two unrelated general partners, Jack Preston and Diane Dunn. Jack has a 75 percent ownership interest in the partnership and Diane has a 25 percent...
-
Approximately a year and a half ago, you were hired as a Contracting Officer of NAVSYSCOM. You were previously employed by Company B, a DoD contractor. WHen you left, you maintained your 401K, but it...
-
5. There are three categories for movie tickets, with the following prices: General admission: $12.50 Senior citizen: Child under 10: $11.00 $9.00 Write a Python program that prompts the customer for...
-
Perform an online search using the words "old economy new economy marketing jobs" and read three (3) related sites. Once you have read the article or articles, use the websites below and any other...
-
Explain this figure from Lee's book. Be sure to provide a discussion on both perceptions as well as outcomes, and follow-on margin improvement projections by Lee. Next, apply this figure to a...
-
The diagram shows the two forces acting on a small object. Which of the following is the resultant force on the object? A. 8 N downwards B. 8 N upwards C. 2 N downwards D. 2 N upwards 3 N 5 N
-
Which of the following statements is true? a. There are three different types of proprietary funds. b. There are three different types of fiduciary funds. c. There are five different types of...
-
A city creates a solid waste landfill. It assesses a charge to every person or company that uses the landfill based on the amount of materials contributed. In which of the following will the landfill...
-
Nascent, Inc., acquires 60 percent of Sea-Breeze Corporation for $414,000 cash on January 1, 2015. The remaining 40 percent of the Sea-Breeze shares traded near a total value of $276,000 both before...
-
Show the details of proving the formula (33.5) for the Shannon entropy in (33.6). Data From Equation 33.6:- H(X) k - p(x) log2 p(x). x=1 (33.6)
-
Consider the harmonic oscillators from exercise 4, connected to a reservoir of temperature \(T\) and chemical potential \(\mu\). Calculate (in the grand canonical ensemble) the thermodynamic...
-
Consider a system \(A \cup B\), with total Hamiltonian diagonalized by states \(|1angle_{A} \otimes|1angle_{B},|2angle_{A} \otimes\) \(|2angle_{B},|3angle_{A} \otimes|4angle_{B},|4angle_{A}...
Study smarter with the SolutionInn App