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.
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.
Thanks for the help,
Please Login or Register to view this content.