Read special character value

Posts
13
Registration date
Thursday May 9, 2019
Status
Member
Last seen
May 28, 2019
- - Latest reply: ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
- May 22, 2019 at 07:32 AM
how to read the cell value in vba if A1 has special character like --------

I used Range("A1").Value , Its throwing an error


plz help me
See more 

1 reply

Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1573
0
Thank you
Ok, so what is changing the value to that, your validator as stated in other posts? If so, then change the value to a -1 or something useful.
Respond to ac3mark