ok i have some code..using option explicit and an error writer i know the error is an undefined lable but i dont see any
Option Explicit
Sub Macro_create()
'' x value charachter count
''Dim i As integer
''i = Len(Cells.Value)
'' y value character count
''Dim j As Integer
''j = Len(Cells.Value)
'' repetitions of the whole program
Dim r As Range
Dim bottomA As Integer
bottomA = Sheets("Macro").Range("A" & Rows.Count).End(xlUp).Row
''integer to keep adding to the bottome of the list
Dim l As Integer
l = 0
On Error GoTo Errorcatch
''If (Range("F4:F2000") > 35737) And (Range("F4:F2000") <> "FAILED") Then
''If (Range("G4:G2000") = "PASS" Or "") Then
''If (Range("I4:I2000") <> "1 Day(s)" Or "2 Day(s)" Or "3 Day(s)" Or "4 Day(s)" Or "5 Day(s)" Or "6 Day(s)") Then
For Each r In Sheets("Macro").Range("A2:A" & bottomA)
''If (Range("F4:F2000") > 35737) And (Range("F4:F2000") <> "FAILED") Then
'' If (Range("G4:G2000") = "PASS" Or "") Then
'' If (Range("I4:I2000") <> "1 Day(s)" Or "2 Day(s)" Or "3 Day(s)" Or "4 Day(s)" Or "5 Day(s)" Or "6 Day(s)") Then
Range("M2+l").Value = "DELAY : 1967"
Range("M3+l").Value = "Mouse : 1238 : 794 : LeftButtonDown : 0 : 0"
Range("M1085+l").Value = "Mouse : R1013 : R95 : LeftButtonUp : 0 : 0"
Range("M1086+l").Value = "DELAY : 272"
l = l + 1100
'' End If
''End If
'' End If
Next r
End Sub
Exit Sub
Errorcatch: MsgBox Err.Description
Bookmarks