Limit Search & Replace's Replace All?

[[email protected]]

I there a way to limit search and replace's (Ctrl + H) replace all to
just a selected cell range, without using VBA?

I like replace all because it is fast, but I'm concerned about it
changing cells I don't want changed.

[davesexcel]

select the range by highliting it,
then find and replace,
this should only replace in the range highlited

[Dave Peterson]

And make sure that the selection contains at least 2 cells--else all cells will
be used.



davesexcel wrote:
>
> select the range by highliting it,
> then find and replace,
> this should only replace in the range highlited
>
> --
> davesexcel
>
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=563969

--

Dave Peterson

[RagDyeR]

Unless you *Don't* use "Replace All" for single cells.
Just click "Replace".
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
And make sure that the selection contains at least 2 cells--else all cells
will
be used.



davesexcel wrote:
>
> select the range by highliting it,
> then find and replace,
> this should only replace in the range highlited
>
> --
> davesexcel
>
> ------------------------------------------------------------------------
> davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=563969

--

Dave Peterson

[Saruman]

Highlight the cells as previously suggested, once you have run the find all,
then re highlight the same selection and if you click replace all, only the
highlighted cells are replaced.

This is in Excel 2003

--
Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Norton Antivirus 2003
---------------------------------------------------------------------------

<[email protected]> wrote in message
news:[email protected]...
> I there a way to limit search and replace's (Ctrl + H) replace all to
> just a selected cell range, without using VBA?
>
> I like replace all because it is fast, but I'm concerned about it
> changing cells I don't want changed.
>