this s part of a larger formula:
Dim c
For Each c In Range("C1:C" & x)
If c = "" Then
MsgBox "Please enter data in cell " & c.Address
c.Select
Exit Sub
End If
Dim x As Integer, counter As Integer, y As Integer, MyArr
Randomize
MyArr = Array(4, 8, 16, 32, 64, 128, 256)
when i try and execute the macro i get this message "Compile error : Duplicate declaration in current scope". And also the line "Dim x as Interger" get highlited.
How should i stop this from happening?
This message was edited by MERKY on 2002-05-02 10:54
Dim c
For Each c In Range("C1:C" & x)
If c = "" Then
MsgBox "Please enter data in cell " & c.Address
c.Select
Exit Sub
End If
Dim x As Integer, counter As Integer, y As Integer, MyArr
Randomize
MyArr = Array(4, 8, 16, 32, 64, 128, 256)
when i try and execute the macro i get this message "Compile error : Duplicate declaration in current scope". And also the line "Dim x as Interger" get highlited.
How should i stop this from happening?
This message was edited by MERKY on 2002-05-02 10:54