Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.Calculation Problems | Excel Worksheet Functions | |||
type mismatch error in Benford's law macro | Excel Programming | |||
Problems using Application.IgnoreRemoteReferences | Excel Programming | |||
Problems with Excel VBA application | Excel Programming |