Hello I have an excel sheet that uses cursor mouse events to copy and paste fields from somewhere on the computer...about every 50th time or so for whatever reason it pastes one of the fields as FALSE...how can I error trap this to loop it back around...I've tried if statements like
If Range ("A1") = "FALSE" Then
But it's not working I dunno if it's because the way it pastes false it's not registered as text or something but let me know maybe something like false without parenthesis or Range ("A1").Text...I know how to loop it so don't worry about that I just need to know why the IF statement isn't recognizing the FALSE text in the cell...thanks!
If Range ("A1") = "FALSE" Then
But it's not working I dunno if it's because the way it pastes false it's not registered as text or something but let me know maybe something like false without parenthesis or Range ("A1").Text...I know how to loop it so don't worry about that I just need to know why the IF statement isn't recognizing the FALSE text in the cell...thanks!
