Posted: 12/29/2004 1:44:20 PM EDT
|
I want to have an input cell so that whatever is in that cell is inserted into the replace portion of a dialog box. However, when I use Ctrl+V in the macro, it takes the current contents only. Therefore, if I change the value of the input cell and run the macro again, it still uses the original contents of the cell. This is the section of code in question: Selection.Replace What:="$Z", Replacement:="$AA", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Can anyone help me out? Thanks. |
|
huh? Are you saying you want to be able to highlight any particular cell, start the macro and have it put that active cell's value into the replace portion of the search & replace function? If that's the case then you're really making it too difficult, I think. Just create a visible button for the Replace... function and CTRL+C, CTRL+V, baby. |
|
I want to have an input cell so that whatever is in that cell is inserted into the replace portion of a dialog box. However, when I use Ctrl+V in the macro, it takes the current contents only. Therefore, if I change the value of the input cell and run the macro again, it still uses the original contents of the cell. Any suggestions? |