C
Chet
Anyone know how to pick out a digit in a string of characters like
this? =---FS- 12345 I am trying to replace the first character and
my code keeps coming back with "type mismatch error 13". My code is
simple (but wrong). I am trying to get rid of the = character and
replace it with a ' .
Thx
Chet
Sub REMOVE_INVALID_DATA_PHX_DOWNLOAD()
MaxRow = ActiveSheet.Range("A65536").End(xlUp).Row
For Rowy = 2 To MaxRow
Target = Left(Cells(Rowy, 11), 1)
If Target = "=" Then Target = "'"
Left(Cells(Rowy, 11), 1) = Target
Next Rowy
End Sub
this? =---FS- 12345 I am trying to replace the first character and
my code keeps coming back with "type mismatch error 13". My code is
simple (but wrong). I am trying to get rid of the = character and
replace it with a ' .
Thx
Chet
Sub REMOVE_INVALID_DATA_PHX_DOWNLOAD()
MaxRow = ActiveSheet.Range("A65536").End(xlUp).Row
For Rowy = 2 To MaxRow
Target = Left(Cells(Rowy, 11), 1)
If Target = "=" Then Target = "'"
Left(Cells(Rowy, 11), 1) = Target
Next Rowy
End Sub