Home

macro and Find and Replace specific cell values

%3CLINGO-SUB%20id%3D%22lingo-sub-413546%22%20slang%3D%22en-US%22%3Emacro%20and%20Find%20and%20Replace%20specific%20cell%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-413546%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20create%20a%20macro%20using%20the%20Find%20and%20Replace%20feature%2C%20The%20value%20I%20want%20to%20find%20whatever%20value%20is%20in%20A2%20and%20I%20want%20to%20replace%20it%20(and%20all%20other%20cells%20in%20the%20sheet)%20with%26nbsp%3B%20whatever%20value%20is%20in%20cell%20A1.%20Note%20I%20want%20to%20be%20able%20to%20change%20these%20A1%20and%20A2%20cell%20values%20and%20rerun%20the%20macro%20at%20a%20later%20date.%20My%20question%20is%20can%20the%20find%20and%20replace%20function%20do%20this%3F%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20619px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F106277i192549140FD594D8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.JPG%22%20title%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-413546%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
frank96
Occasional Visitor

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?Capture.JPG

Related Conversations
not able to type number and text in same cell?
Deleted in Excel on
2 Replies
Pivot table
gabriellerocha in Excel on
5 Replies
Break or Pause during Replace command
Quality2663 in Excel AMA on
5 Replies
Macro issue with email connectivity
unhappyuser in Excel on
21 Replies
Excel Table Size in Macro
WayneEK in Excel on
6 Replies