Read special character value

Sanju_7454 Posts 13 Registration date Thursday May 9, 2019 Status Member Last seen May 28, 2019 - May 21, 2019 at 07:05 PM
 Blocked Profile - 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

1 response

Blocked Profile
May 22, 2019 at 07:32 AM
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.