I understand that I have to set the definition and declare the data type, but
I can't figure out how to accomplish that. Everything that I have tried has
resulted in an error. I realize it is something obvious, but I just can't
see it.
"Jim Cone" wrote:
If the "I" character is not part of the alphabet then you
will get an error.
Also, unless you declare the data type for each variable it will be a variant.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"Sody"
wrote in message
I am still trying to get the Benford's law application to run. The
application creates the variables for running the application. The variables
are as follows:
Dim One, Two, Three, Four, Five, Six, Seven, Eight, Nine, Zero, firstone
Dim Row As Long, Col As Long, Step As Long, Ez
Dim Z As Long, Total
Dim Digits As Long
Dim X, I
The application goes through three loops to count and accumulate the
relevant data. The last loop is to enter the counts of the first two digits
test into a worksheet. That part of the procedure is as follows:
Worksheets(4).Select
Range("3").Select
For I = 10 To 99
ActiveCell.Offset(1, 0).Select
ActiveCell.Value = Arraytwotest(I)
Next I
This part of requires the definition of I set forth in the variable
definitions but I keep getting an error message in the last line of the
variable definition "Dim X, I" I know I am overlooking something obvious but
this is all new to me. Any help will be appreciated.