Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
Is there any solution besides Esc and Ending the program. Thank you |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Once it stops doing the replace, you can hit ZTRL+Z (or Edit/Undo Replace) to
return to the state before you started the incorrect Replace. "Nekodvoru" wrote: Hello, Is there any solution besides Esc and Ending the program. Thank you |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you.
Is it possible to write a procedure to automate clicking Esc button-the problem is I have to many links in files that give Reference error when doing find/replace "Wiley" wrote: Once it stops doing the replace, you can hit ZTRL+Z (or Edit/Undo Replace) to return to the state before you started the incorrect Replace. "Nekodvoru" wrote: Hello, Is there any solution besides Esc and Ending the program. Thank you |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for the feedback. I don't know of a way of using the escape key in a
macro. One way is to jsut do a FInd Next and Replace, rather than ERpalce ALL? Can you give an example of how the Find and Replace give you errors? Perhaps we can help you refine the Find/Replace. "Nekodvoru" wrote: Thank you. Is it possible to write a procedure to automate clicking Esc button-the problem is I have to many links in files that give Reference error when doing find/replace "Wiley" wrote: Once it stops doing the replace, you can hit ZTRL+Z (or Edit/Undo Replace) to return to the state before you started the incorrect Replace. "Nekodvoru" wrote: Hello, Is there any solution besides Esc and Ending the program. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stop Excel from stripping out leading zeros when saving as CSV | Excel Discussion (Misc queries) | |||
How to stop Excel remembering/loading macro from previously opened Workbook | Excel Discussion (Misc queries) | |||
Excel find/replace should allow values to be pasted in. | Excel Worksheet Functions | |||
Excel Find/Replace Dialog Box | Excel Discussion (Misc queries) | |||
How do I stop Excel auto formatting the text 3-4 as 04 Apr? | Excel Discussion (Misc queries) |