| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find replace within sheet or workbook
Is there a way to change the search within feild in the replace command from
"sheet" to "workbook"? ie something like: Cells.Replace What:="a", Replacement:="b", Within:=xlSheet The within option in replace doesn't seem to be covered in VB Cells.Replace yet Cells.Replace is effected by what ever the Within option is set to using the normal find/replace command in excel. The only other idea I have come up with is using sendkeys but sendkeys may not be very robust. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set the Find and Replace, Options, 'Within' default to Workbook | Excel Discussion (Misc queries) | |||
| Find and Replace within workbook - from Visual basic | Excel Programming | |||
| find and replace within workbook macro | Excel Discussion (Misc queries) | |||
| find and replace, within workbook | Excel Discussion (Misc queries) | |||
| Find / Replace sheets vs workbook in VB | Excel Worksheet Functions | |||
Threaded Mode
