title: VBA: How to check with an if condition if a column's cells (known column number) equal to a value?
body: <p>I am new to VBA so it might be a simple question. </p>
  
  <p>Firstly, I search into a sheet to find the column number including the word "TABLES".</p>
  
  <p>Then, I want to check if this column's cells equal to a number between 400 to 450 and when the condition is true I create a print preview.</p>
  
  <pre><code>Sub CustomPrint()
  
  Dim Lost As Variant
  
  Lost = TABLES
  
  With ActiveSheet.Range("A1").CurrentRegion
  Set c = .Find(Lost, LookIn:=xlValues)
  End With
  
  For i = 400 To 450 Step 1
  If (ActiveSheet.Columns(c).Value = i) Then ActiveSheet.PrintOut preview:=True
  Next
  
  End Sub
  </code></pre>
  
  <p>ActiveSheet.Columns(c).Value = i -> This is where I get the error message.</p>
  
  <p>Thank you in advance.</p>