Replace...

Home Search Site Map

Up
Clear
Copy
Cut
Delete...
Delete Sheet
Fill
Find...
Go To...
Links...
Move or Copy Sheet...
Object
Office Clipboard...
Paste
Paste as Hyperlink
Paste Special...
Redo
Replace...
Undo

New! Excel User Group Now Open @ www.excelusergroup.org, Check It Out!


Menu command Type What happens next?
Replace... ...

Uses the same dialog as 'Find' and in fact, if you look at the 'Find' option dialog (Above), you will see the 'Replace' tab. Takes a search text and replaces any occurrences it finds with the supplied new text. Single occurrences can be replaced all at once. The same options in the dialog for 'Find' are available.

Sub UseReplace()
Range("A1:A100").Replace What:="Nck", _ Replacement:="Nick"
End Subub

Copyright Nick Hodge 2008. All Rights Reserved.