Hi
I get an error when i try to run this script/macro
Public Sub Stat()
Dim X As Range, Y As Range
Dim A As Variant, B As Variant, C As Variant, D As Variant, E As Variant, F As Variant
For Each X In Workbooks("stat3_syd_q1.csv").Worksheets("stat3_syd_q1").Range("B1", "B65536")
If Not X.Offset(0, 3).Value = "" Then
If Not X.Value = "Kommunenr." Then
For Each Y In Workbooks("stat3_SYD07.csv").Worksheets("stat3_SYD07").Range("B1", "B65536")
when i debug it marks the line that starts with For each
i checked to make sure the filename was spelled correct 
Anything ive forgotten?
Solved: Error is caused by file not found
Bookmarks