Thread: Macro wont run!
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Joe
 
Posts: n/a
Default Macro wont run!

So now the macro reads as:

Sub splitdata()

Dim i As Variant
Dim j As Variant
Dim k As Variant
Dim a As Variant
Dim c As Range 'current
Dim n As Range 'next

Set c = Worksheets("RAWdata").Range("A2")

i = 2
j = 2
k = 2

Do While Not IsEmpty(c)
Set n = c.Offset(1, 0)
Sheets("RAWdata").Select
a = Len(Cells(i, "A"))

If a < 9 Then
Sheets("RAWdata").Select
Range(Cells(i, "A"), Cells(i,
"O")).Copy

Sheets("IRdata").Select
Range(Cells(j, "A"),
Cells(j, "O")).Select
ActiveSheet.Paste
j = j + 1

Else
Sheets("RAWdata").Select
Range(Cells(i, "A"), Cells(i,
"O")).Copy
Sheets("FLSdata").Select
Range(Cells(k, "A"),
Cells(k, "O")).Select
ActiveSheet.Paste
k = k + 1

End If
i = i + 1
Set c = n
Loop
End Sub