VBA NumberFormat General, not working for all the cells

[BKChedlia]

Hi,
I would like to format a excel file to "General", but it's not working for all cells (some are custom, pourcentage...).
here is my code :

  With ActiveSheet.Range("A1").Resize(LineIndex, 1)
        .Value = WorksheetFunction.Transpose(strLine)
        .NumberFormat = "General"
        'DEFINE THE OPERATION FULLY!!!!
        .TextToColumns Destination:=.Cells(1), DataType:=xlDelimited, _
                       TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, _
                       Tab:=False, Semicolon:=False, Comma:=False, Space:=False, _
                       Other:=True, OtherChar:="|"

help please.

 

[mikerickson]

If it isn't working, what is it doing?