VBA Check if a column is TAB delimited

[decadence]

Hi, Is it possible to check if a column of data is TAB delimited, can someone help with this please

 

[Peter_SSs]

1. Select the column & do Text to Columns with a Tab delimiter (& undo if required), or
2. =COUNTIF(L:L,"*"&CHAR(9)&"*") Tells you how many cells in the column contain at least 1 tab character.

Is that what you wanted?

 

[decadence]

Hi Peter, I am trying to do an if statement whether the data in Column A contains them or not as I will be adding code to determine what to do next

 

[Peter_SSs]

Hi Peter, I am trying to do an if statement whether the data in Column A contains them or not as I will be adding code to determine what to do next

Sorry, I missed in your thread title that it was a VBA question.
I'm signing off for the night now but I'll have a look to see if it has been resolved next time I'm on the forum.

Edit: BTW, exactly what do you mean by "column A contains them"?
- Every populated cell in column A contains at least 1 tab
- Every populated cell in column A contains the same number of tabs
- At least one cell in column A contains at least 1 tab

 

[DanteAmor]

Try this

If you want to check cell by cell which one has Tab:

Sub test()
  Dim c As Range
  For Each c In Range("A2", Range("A" & Rows.Count).End(xlUp))
    If InStr(1, c, vbTab) Then
      MsgBox "The cell contains tab delimited:" & c.Address
      'here your code
    End If
  Next
End Sub

---

If you want to find the first Tab:

Sub test2()
  Dim c As Range
  Set c = Range("A:A").Find(vbTab, , xlValues, xlPart)
  If Not c Is Nothing Then
    MsgBox "The cell contains tab delimited:" & c.Address
    'here your code
  End If
End Sub

 

[decadence]

Thank you DanteAmor, this is exactly what I was looking for

 

[Peter_SSs]

.. this is exactly what I was looking for

As a matter of interest, which one?

 

[DanteAmor]

Thank you DanteAmor, this is exactly what I was looking for

I'm glad to help you. Thanks for the feedback.