Checking if cell contains a string or a number

[Djblois]

If Not IsNumeric(Range(Cells(2, lColNum), Cells(finalrow(wsWorking), lColNum))) Then ' It keeps crashing on this line
comProper Range(Cells(2, lColNum), Cells(finalrow(wsWorking), lColNum))
Else
Range(Cells(2, lColNum), Cells(finalrow(wsWorking), lColNum)).TextToColumns _
Destination:=Range(Cells(2, lColNum), Cells(finalrow(wsWorking), lColNum))
End If

wsworking is already defined as the current worksheet
lcolnum is defined as the current column
comproper is a procedure I have created to strings into proper format

[figment]

what is the error message?

[Norie]

Daniel

If it's crashing on the line indicated it could be due to what I mentioned in your other thread - unqualified references.

[Djblois]

I will try that norie