Vba remove numbers from string

lngLastC = .Range("C65536").End(xlUp).Row
 Dim rn As Integer
 rn = 1
 ReDim strName(intNumRunners)
 For Each rngRunners In .Range("C3:C" & lngLastC)
 strName(rn) = rngRunners.Value
 [B]strName(rn) = Replace(strName, IsNumber, "")[/B]
 strName(rn) = RTrim(strName(rn))
 rn = rn + 1
 Next rngRunners

Source: ozgrid.com

Similar codes

0 vote160 views1 answer
Excel vba combine ranges
VBA
0 vote207 views1 answer
Excel vba protect content
VBA
0 vote163 views1 answer
Average vba
VBA
8 votes210 views1 answer
Excel vba make word
VBA
0 vote190 views2 answers
Get unique random number in vb.net
VBA
0 vote154 views1 answer
Excel vba join variant array
VBA
0 vote153 views1 answer
Enter into cells data grid view
VBA
0 vote161 views1 answer
Vba static variable
VBA
5 votes170 views1 answer
Excel vba left word from Long Integer
VBA
0 vote167 views1 answer
Pivot data source not accepting table named range vba
VBA