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 vote341 views1 answer
Excel vba populate array with cell values
VBA
0 vote366 views4 answers
How to continue formula in below line in vba code
VBA
0 vote354 views1 answer
Excel vba scroll to cell
VBA
3 votes387 views2 answers
Vba date to string
VBA
3 votes336 views1 answer
Excel vba last row in range
VBA
1 vote423 views1 answer
Perform http request in vb.net
VBA
0 vote366 views1 answer
Search for text in every worksheet excel visual basic
VBA
2 votes387 views2 answers
Excel vba if sunday or staurday
VBA
0 vote384 views1 answer
Nested if else in vb.net
VBA
5 votes403 views1 answer
Excel vba left word from Long Integer
VBA