Hi all,

I want to read in the value of a string for comparison purposes that has been passed from an excel(cell) through VBA. When the value is read into a string variable, some of them contain, carriage return characters(A square box). how can I determine the ascii character value of the carriage return? I attempted to read the chr(13) value, but this did not do want i needed.

Here is what i have so far:

Code:
    Dim i As Integer
        Dim sectionHolder As String
    
        i = 1
        
        Do Until i = Len(sectionName) + 1
            If Mid(sectionName, i, 1) <> Chr(13) Then
                sectionHolder = sectionHolder + Mid(sectionName, i, 1)
                i = i + 1
            Else
                Exit Do
            End If
                
        Loop