| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with find and replace macro
bhofsetz wrote: Dave, You are getting the error message on this line rOldHds.Select 'TEMP becase the workbook and worksheet on which you are trying to select that range are not the active book and sheet. You would either have to manually select that book and sheet or do it in the code with: HeadersBk.Sheets(1).Activate then rOldHds.Select 'TEMP I also noticed that you are counting rows on Sheet(19) and then selecting the range on Sheet(1). Is this correct? Thanks! It's working fine now. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Find and Replace | Excel Discussion (Misc queries) | |||
| Find & Replace in VB macro | Excel Discussion (Misc queries) | |||
| find replace macro | Excel Programming | |||
| Find/replace macro | Excel Programming | |||
| find and replace macro need help | Excel Programming | |||
Hybrid Mode
