Read special character value

Report
Posts
13
Registration date
Thursday May 9, 2019
Status
Member
Last seen
May 28, 2019
-
 Blocked Profile -
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 reply


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.