LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default More problems witn Benford's law application

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Application.Calculation Problems Jive Excel Worksheet Functions 2 February 7th 08 02:21 PM
type mismatch error in Benford's law macro Sody Excel Programming 1 May 24th 06 11:07 PM
Problems using Application.IgnoreRemoteReferences JGeniti Excel Programming 2 August 12th 05 01:33 PM
Problems with Excel VBA application [email protected] Excel Programming 2 June 12th 05 05:38 PM


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"