| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using .Replace
How can I find and replace for a certain range? I'd
rather not use Cells.Replace.... and search the entire sheet: Sub Worksheet_Activate() Set area = Sheets("Layout-Bulk (2)").Range("A7:BR53") For Each cell In area .Replace What:="##", Replacement:="=" Next cell End Sub Thx. Jason |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
| Replace dialog should put focus on "Find What" not "Replace With" | Excel Discussion (Misc queries) | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| How can I use replace(alt+H) for mutiple items needing replace | Excel Worksheet Functions | |||
![Jason Morin[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
