title: VBA file exists from column
body: <p>It's my first time writing macros and I am not able to see why this does not work</p>
  
  <pre><code>   Sub fillColumnStatus()
   Dim LPath As String
   Dim LExtension As String
   Dim SRow As Integer
  
   SRow = 4
   Path = Application.ActiveWorkbook.Path
   LPath = "C:\Users\Files"
   LExtension = ".pdf"
  
  
   While (SRow &lt; 1131)
           If Len(Range("A" &amp; CStr(SRow)).Value) = 0 Then
              Range("B" &amp; CStr(SRow)).Value = ""
          Else
              If Len(Dir(LPath &amp; Range("A" &amp; CStr(SRow)).Value &amp; LExtension)) = 0 Then
              Range("B" &amp; CStr(SRow)).Value = "Check"
              Else
              Range("B" &amp; CStr(SRow)).Value = "No"
              End If
          End If
       SRow = SRow + 1
    Wend
  End Sub
  </code></pre>
  
  <p>Empty cells are correctly displayed, but I got only not found for all file.</p>
  
  <p>Thanks, </p>