I want to create a macro using the Find and Replace feature, The value I want to find whatever value is in A2 and I want to replace it (and all other cells in the sheet) with whatever value is in cell A1. Note I want to be able to change these A1 and A2 cell values and rerun the macro at a later date. My question is can the find and replace function do this?
