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 vote162 views1 answer
Hello world vb.net
VBA
4 votes180 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote164 views1 answer
Send webhook vbscript
VBA
0 vote166 views1 answer
Remove last 8 characters from string vb
VBA
0 vote161 views1 answer
Excel vba address not absolute
VBA
1 vote155 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote181 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote158 views1 answer
Get current year vb
VBA
5 votes113 views1 answer
Vlookup vba
VBA
0 vote156 views1 answer
Excel vba disable screen update
VBA