How to check a string?

[sanjna000]

Hi there,

In VBA how do u check whether a particular cell value has a string value in it?

I need to check my current cell value has a 'character value' in it. If there is a string value, i need to replace with a number, otherwise need to add the second number into already available number.

Thanks a lot for u r help in advance
Sanjna...

 

[SkipVought]

Sanjna,

With Cells(r, c)
   If Len(.Value) > 0 Then
      If IsNumeric(.Value) Then
        'houston, we have a NUMBER"
  
      Else

      End If
   End If
End With

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[sanjna000]

Thank you so much Skip. You are a STAR !!!

Sanjna...