Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find and Replace
We have worksheets that have to be copied forward in the new year. These
worksheets refer some worksheets that have not been copied in the new year. So when we do a find and replace from 03 to 04 we have to hit "cancel' sometimes hundreds of times because the files they are referring to have not been copied into the new year yet. Is there some way to suspend the looking for the new referenced file? |
#2
|
|||
|
|||
hi
the keyboard keys Cntl+Break will stop the macro if that is what you're wanting. -----Original Message----- We have worksheets that have to be copied forward in the new year. These worksheets refer some worksheets that have not been copied in the new year. So when we do a find and replace from 03 to 04 we have to hit "cancel' sometimes hundreds of times because the files they are referring to have not been copied into the new year yet. Is there some way to suspend the looking for the new referenced file? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Find and Replace All | Excel Worksheet Functions | |||
Can I use Find and Replace all with Hyperlinks? | Excel Discussion (Misc queries) | |||
find replace cursor default to find box | Excel Discussion (Misc queries) | |||
macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
VB Find and Replace | Excel Worksheet Functions |