I'm trying to record a macro that finds and deletes (replaces with "") all instances of a special character, namely "★", in a spreadsheet.
When I use the find and replace function this works perfectly, but when I record it into a macro it doesn't recognise it and replaces the instance in the code with a question mark:
I'm sure this is quite simple but I can't see a similar post in the forum to refer to.
Please Login or Register to view this content.
many thanks for all your help!