I have a cell that will be used for a filename when a user exits Excel.
I have a button that the user clicks that executes other macros after they are done entering data.
I need a macro that will search the contents of the "filename cell" and find special characters and then replace them with something else.
!!!!!!PLEASE HELP!!!!!! I don't know much about programming (probably obvious).