Replace special characters macro not looping through cells

Hi,

I have a macro that will ask the user to open a workbook, select a specific sheet and then ideally it will search all the cells in that workbook to find special characters. When it finds the characters it asks the user if they want to replace it or not, if no it will continue on and if yes it will replace it and continue on.

Issues;
A) It asks the user to confirm the replacing of each special character it finds in 1 cell, and once done with that cell it stops. It will not go to another cell until I run it again (and there are no special characters to replace in the previous cell). So I need it to loop through the entire worksheet rather than stop after its job is done on one cell.

I am also unsure how it will handle characters I have selected to not replace once it starts looping? Is there a way to ensure it only does one loop through the worksheet?

B) It seems to skip Cell A1 for some reason, not a huge deal as long as it does Cell A1 eventually, just odd.

Please Login or Register  to view this content.

Thanks for the help,
Mattyfaz

Originally Posted by mehmetcik

You need to keep looping until you find the first special character or there are no special characters on the sheet

Thanks for the help but I am getting the below error:
Run-Time error '91':
Object variable or With block variable not set

Any advice?

Please Login or Register  to view this content.

Also, will this skip something if I selected that I do NOT want to change that character?