VBA for Edit-Find-Replace

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Friends,

I am trying to write VBA code that references two cells in the ActiveSheet -
Cell_1 and Cell_2. The code needs to take the value from Cell_1 and place it
iin the "Find What" text box of the Edit/Find dialog box. Then it needs to
take the value from Cell_2 and post it to the "Replace With" text box of the
Edit/Find/Replacedialog box.
The code also needs to ensure that Excel will "Search" rows and "Look in"
formulas.

Is there a way to do this with VBA? You don't have to write all the code for
me, but if you could nudge me in the right direction, I would be grateful.

Thanks for your help ...

Bill Morgan
 
bill_morgan_3333 said:
Friends,

I am trying to write VBA code that references two cells in the
ActiveSheet - Cell_1 and Cell_2. The code needs to take the value
from Cell_1 and place it iin the "Find What" text box of the
Edit/Find dialog box. Then it needs to take the value from Cell_2 and
post it to the "Replace With" text box of the Edit/Find/Replacedialog
box.
The code also needs to ensure that Excel will "Search" rows and "Look
in" formulas.

Is there a way to do this with VBA? You don't have to write all the
code for me, but if you could nudge me in the right direction, I
would be grateful.

Thanks for your help ...

Bill Morgan
Click to expand...

I think you'd better post your question in one of the Excel newsgroups,
maybe <microsoft.public.excel.programming>. This one is for questions
about programming Microsoft Access, the database product.
 
Back
Top