is it empty or not?

[UALynn]

I have opened a text file into a workbook.
If I insert a formula in the workbook =len(B2) it returns a value of 0 for cells where I don't see any text.
However, in VBA when I do a len on the same cell I get a return of 252.

Debug.Print Len(.Range("B2"))

So I can't tell if the cell is empty using isempty because it thinks something is there.

[NateO]

Odd. Having some difficulty baking up a replication to the issue.

Use the Application object's clean() and trim() functions.

[UALynn]

I found a work around.
Open the txt file

strGrps = "C:\Whatever.txt"
    Set myBk = myXlObj.Workbooks.Open(Filename:=strGrps)

then do a saveas and convert to a xls file

 strGrps = "C:\Whatever.xls"
    myBk.SaveAs Filename:=strGrps, FileFormat:=xlWorkbookNormal

close it all up, set back to nothing, reopen the xls file and all works as it should.

Weirdness.

[Tom Urtis]

That really is wierd but a nice workaround.

UALynn - - is the text file imported from some other software program, and if so what is that software program?

[NateO]

That's not weird. It's the beauty of Excel!

Wrong thread eh.

[UALynn]

UALynn - - is the text file imported from some other software program, and if so what is that software program?

Its an export from Lotus Notes.

[Tom Urtis]

Thanks...good to know for future encounters with LN.