software

Is it possible to run Find and Replace from a macro where it picks up
the 'find' and the 'replace' data from the data in two cells on the
sheet?

Any ideas?

Thanks--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=495314Record a macro while doing it manually.
Then edit the macro.
What:=Range(quot;whatever you wanted to replacequot;) becomes What:=Range(quot;a1quot;)
similar for the value to replace it with

--
Kind regards,

Niek Otten

quot;Brisbane Robquot; gt;
wrote in message
news:Brisbane.Rob.20epay_1135196101.7246@excelforu m-nospam.com...
gt;
gt; Is it possible to run Find and Replace from a macro where it picks up
gt; the 'find' and the 'replace' data from the data in two cells on the
gt; sheet?
gt;
gt; Any ideas?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; Brisbane Rob
gt; ------------------------------------------------------------------------
gt; Brisbane Rob's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25096
gt; View this thread: www.excelforum.com/showthread...hreadid=495314
gt;
something like this

Sub findreplace()
Range(quot;e14:e18quot;).Replace What:=quot;xquot;, Replacement:=quot;yquot;, LookAt:=xlWhole
Range(quot;e16:e18quot;).Replace What:=[e14], Replacement:=[e15], LookAt:=xlWhole
End Sub

--
Don Guillett
SalesAid Software

quot;Brisbane Robquot; gt;
wrote in message
news:Brisbane.Rob.20epay_1135196101.7246@excelforu m-nospam.com...
gt;
gt; Is it possible to run Find and Replace from a macro where it picks up
gt; the 'find' and the 'replace' data from the data in two cells on the
gt; sheet?
gt;
gt; Any ideas?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; Brisbane Rob
gt; ------------------------------------------------------------------------
gt; Brisbane Rob's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25096
gt; View this thread: www.excelforum.com/showthread...hreadid=495314
gt;

Thanks, Neik, your help much appreciated--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=495314
Thanks Don!

Much appreciated--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=495314