Clarification on '"counters".

Ddangelo

New Member
Joined
Dec 17, 2013
Messages
16
Hello everyone. I'm looking at a program an intern did while ago, and am trying to teach myself Vb. I'm picking up on it, but I needed a couple VBA terms clarified. First is counters. The program has the following code in it. What do the " 'counters for rows and each frame size " as well as the (i = 0, j = 0 ....etc.) mean? Thank you for any help provided!

Function winRatioGen()
Dim cell As Range 'array for each row

'declear an array for each frame size. Can only fit 500 points. update as necessary
Dim Frame10(500) As Double
Dim Frame15(500) As Double
Dim Frame20(500) As Double
Dim Frame25(500) As Double
Dim Frame29(500) As Double
Dim Frame32(500) As Double
Dim Frame38(500) As Double
Dim Frame46(500) As Double
Dim Frame56(500) As Double
Dim Frame60(500) As Double
Dim Frame70(500) As Double
Dim Frame78(500) As Double
Dim Frame88(500) As Double
Dim Frame103(500) As Double
Dim Frame110(500) As Double

'counters for rows and each frame size.
i = 0
j = 0
k = 0
l = 0
m = 0
n = 0
o = 0
p = 0
q = 0
r = 0
s = 0
t = 0
u = 0
v = 0
w = 0
x = 0
y = 0
z = 0
a = 0
b = 0

'only take into account the data after autofilter.
Dim rng As Range
Dim cellRow As Integer

Set rng = Worksheets("Baseline").Range("AT3:AT500").SpecialCells(xlCellTypeVisible)
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
For example

Dim Frame10(500) As Double

Defines Frame10 as an array of real (decimal) numbers with 500 values.

i=0

just sets the value of i to zero but is unnecessary here as the default is zero anyway.
 
Upvote 0
So does this mean then that the letters = 0 can be completly taken out since they are unnecessary?
 
Upvote 0

Forum statistics

Threads
1,215,364
Messages
6,124,509
Members
449,166
Latest member
hokjock

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top