======================================================================
[Software name          ] Regular Expression Find
[Version                ] Ver 2.83
[Kind of software       ] Freeware
[Runnable OS            ] Windows XP/Vista/7/8/10
[Necessary thing        ] Microsoft Excel 2000 over
[Development language   ] Excel VBA
[Date of publication    ] 2015/09/23
[Copyright              ] Copyright(C) K.Hiwasa
[URL                    ] http://srcedit.pekori.jp
[E-mail                 ] srcedit@a.pekori.jp
[Development environment] Windows 7/Microsoft Excel 2013
[Condition of reprint   ] Contact
======================================================================
[Introduction of software]
Excel add-in that shows dialog of find and replace by regular expression.
Install this, you can do flexible search by regualr expression in Excel.
Easy to use because interface is similar to excel standard find dialog.
There are following functions mainly.
- Find and replace by regular expression
- Worksheet functions by regular expression
- Data extract (substitute for regular expression auto filter)
- Find, replace, grep, and grep replace in auto shapes
- Grep and grep replace in Excel files
- Find and replace VBA codes in VBE
You can customize shortcut key of dialog open.
Introduction is easy because you install and uninstall automatically.
Runnable by Excel 2000 over.


[Update of this version]
- Added "Show all" button to "Find" tab.


[Files]
excelre.xla     : Body of tool.
readme.txt      : Japanese version of this file.
readme_e.txt    : This file.
FunCustomize.dll: Library of function customize.
                  (By Mr. Laurent Longre. http://xcell05.free.fr/)
auto.xla        : Add-in for auto update.
update.xla      : Add-in for update.


[Way to install]
You must do following thing after unzip.
- Auto install (recommended)
  Need Excel can use macros.
  Execute excelre.xla, copying files to common add-in folder
  (If no authority of common add-in folder, copy files to user add-in folder.)
  and register the file as add-in.
  Because Files that you execute are copied, you may delete them.
  Common add-in folder (XX is deferent by Excel version)
  C:\Program Files\Microsoft Office\OfficeXX\Library
  User add-in folder
  In case of XP
  C:\Documents and Settings\[user name]\Application Data\Microsoft\AddIns\
  In case of Vista/7/8
  C:\Users\[user name]\AppData\Roaming\Microsoft\AddIns\

- manual install
  You can't do auto install when you have no autority of both common add-in folder 
  and user add-in folder.
  In such case, Install by the following way.
  Select excelre.xla in the add-in manager.

You can use dialog.
You don't have to restart Excel.
Default shortcut key to call dialog is Ctrl+R.
Also you can call dialog by right click menu.
After install, you can turn on and off function in the add-in manager.


[Way to uninstall]
Push unistall button, unregister add-in and delete files in add-in folder.
Though this add-in name remains in list of add-in manager, 
select it, you can delete it.
Not using registry.


[Way to version up]
- Auto update (recommended)
  If update version exists, message is displayed at bottom of window.
  Click there, do version up automatically.
  Settings are succeeded from previous version.

- Update by update button (recommended)
  After download update version, unzip.
  Push update button in version tab and select "update.xla" in update version,
  version up is done.
  Settings are succeeded from previous version.

- Manual update
  After uninstall previous version, install new version.
  Or, not uninstalling previous version, turn off this add-in at add-in manager,
  install new version. Then settings are succeeded from previous version.
  By this way, also complement dictionary file can be succeeded.


[Notice]
  In very rare case, cause isn't clear, failing install or uninstall, 
  and you can't open Excel.
  In such case, recover by the following way.
  (1)Terminate Excel.
  (2)Delete "excelre" Folder in common add-in folder or user add-in folder.
  (3)Open registry editor, delete the following key.
     (Excel settings are initialized. the key is made again after open Excel.)
     HKEY_CURRENT_USER\Software\Microsoft\Office\XXXX\Excel
     (XXXX is deferent by Excel version.)
  (4)Open Excel.


[Find and replace]
- If "Find what" is empty, you can't find.
  If you want to find blank cell, use Excel standard find dialog.
- You can select "Auto" or "Row" or "Column" in search direction.
  When you select "Auto", "Row" or "Column" that is faster is automatically selected.
  To be concrete, if find range is column selection, "Auto" is "Column", unless "Row".
- Find range is whole worksheet if 1 cell is selected. Unless, selected range.
  You can select mutiple ranges.
  You can select multiple worksheets. But if you select ranges in each worksheet,
  selected range in active worksheets is applied to other worksheets.
  Becase Excel specification where selected range in not active worksheet will be 
  same range in active worksheet when select multiple worksheets after select 
  range in each worksheet.
  When you select object like textbox, after select A1 cell, start find or replace.
- If you check "Only string values", target only string value cell.
- If you don't check "Find values", search formulas and if you check it, search values.
  Direct input cells, not formula, are targeted in both cases.
  At formula Search, cells over max formula characters (Excel97-2003: 1024 characters,
  Excel2007: 8192 characters) are searched by value.
- If you check "Find whole workbook" and find or replace, selected range is released.
  If you select sheets not worksheet, after select next worksheet, do find and replace.
- You can change decoration of match part in cell.Running heavily a little.
  (Function of change in decoration sub window)
  Immediately after find, you can undo changing decoration by undo button.
  If you check "Not undo", you can't undo, but running lightly a little.
- If you check "Incremental search", when you input in "Find what" in "Find" tab,
  do incremental search. When input, find next including current cell and when delete,
  find previous not including current cell.
- You can save as many as 10 find patterns.
- You can save as many as 10 replace patterns.
- You can keep 10 results of "Find all".
- After "Find all", you can change size of dialog.
- Because replace is run by VBA, you can't Excel undo.
  But immediately after replace, you can undo replace. (undo function)
  Unless you can do undo function, after unintended replacing, close file not saving
  and open file again.
- If you check "Confirm when replace", you can confirm before replace.
  At "Replace all", "No confirm" is replace all without confirmation after that.
  At "Replace all", "Cancel" is cancel of replace after that.
- If you check "Keep decoration", though running heavily a little, decoration of characters
  in cells are kept. In this case, undo function can undo decoration of characters too.
- By \n in "Replace with", you can insert new line.
- If you check "Additional", target is match for "Find what" and match for 
  additinal condition. If you check "Deny" too, target is match for "Find what" and
  not match for additinal condition.
  (Additional condition sub window)
- If you check "Cross lines", you can search over new lines in cells.
- If formula error occurs after replace, don't replace.
- After "Find all", you can "Replace sel". All selected items in list will be replaced.
  After "Find all", all items are selected.
  You can select or release by double click or space key.
  You can use all select button and all release button too.
- If you push "Start pos" button, back to cell before find or replace.
- You can stop process during "Find all" and "Replace all" by "Cancel" button.
- You can find in sequence by holding "Find next" or "Find previous" button.
- If regular expression meta characters don't exist in "Find what", 
  uses standard find. 
  If you don't want to use standard find, then set on "Not use standard find".
- At "Select all", do find all and select all hit cells or rows or columns.
  You can't find in multiple worksheets.
- At "Outline", do find all and show all hit rows or columns.
  You can't find in multiple worksheets.
- At "Show all", after hide all cells in worksheet,
  do find all and show all hit rows or columns.
  You can't find in multiple worksheets.


[Shape]
- By "Find all", finds all autoshapes in the worksheet, changes color of match part.
- By "Replace all", finds all autoshapes in the worksheet, replaces match part and
  changes color of replaced part.
- If you check "Confirm when replace", you can confirm before replace.
  At "Replace all", "No confirm" is replace all without confirmation after that.
  At "Replace all", "Cancel" is cancel of replace after that.
- Grouped autoshapes isn't target, but if you check "Release group", as execute
  releasing groups at first, is target. At last undo groups.
- You can't shape find and replace in shared workbooks.
- At "select all", do find all and select all hit shapes.
  You can't find in multiple worksheets.
  And you can't do after ungrouping.


[Sheet]
- To all sheets in active workbook, replace sheet name or header or footer.
- To header or footer, you can empty "Find what" and set in empty header or footer.
- If error will occur after replace, don't replace to the sheet.
- You can use special constants for page setup in "Replace with".


[Rename]
- Search and replace file name in a folder.
- At replace, if "Replace with" is empty delete, unless rename.
- Files that couldn't be replace or delete is colored red in result list.
- After rename, you can undo to former file name at "Undo" button.


[Name]
- Search and replace define name in current workbook.


[Split]
- Split contents of cell in selected range with string matched to regular expression
  as delimiter, and set from right next cell in order.
  Split 1 cell is set in 1 row.
- If you check "Switch row and column", split 1 cell is set in 1 column.


[Extract]
- You can't use regular expression with autofilter extraction. Instead flag
  match cells for regular expression in column.
- Specify search target column in "Column from" with A1 form.
  When empty, "Column from" is column of active cell.
- Specify column that will be flagged in "Column to" with A1 form.
- If match cell exists, set "1" to the row of "Column to".
- You can't use special find.


[Grep]
- You can do grep in Excel files with regular expression.
- If Excel2007 over, extension is ".xls?", but target ".xls" failes too.
- You can use wild cards in "Object file".
  If "Object file" is empty, same as you input "*", and targets all files.
- When file can't be opened as you open same name file, the file is skipped.
- Hide worksheets are not searched.
- If you check "Include subfolder", you can find in zip archives (without password).
  You can't find zip archive in zip archive.
- If you check "Open file", do grep in opend files.
- If you check "Grep history off", you can't see search result in progress,
  but get faster.
- If you check "Offset", also show information of cell specified from hit cell.
  For example, if "Row":0 and "Column":1, show right next cell to hit cell.
- If you check "Exec at idle time", when Excel is idle during specified minutes, 
  executes grep. When not idle, suspends grep. 


[Grep Replace]
- You can do grep and replace in Excel files with regular expression.
- Excel files that were done replace is saved.
- If you check "Create backup", backup file whose extension is ".bak"
  will be made in the same folder.
- If formula error occurs after replace, don't replace and cell of formula
  in the result list is colored red.
- If protected worksheets, don't replace and cell of value and formula
  in the result list is colored red.


[Grep Shapes]
- Grouped autoshapes is released, and all autoshapes are targeted.
  If "Grep replace", undo grouping.
  Color of match part isn't changed.
  When you click value of result list, jump to the cell of upper left of autoshape.
  If shapes in not worksheet is hit, hyperlink is to only workbook.
  Except these thing, the specification is same as Grep.
- If you check "Include subfolder" at shape grep, you can find in zip archives (without password).
  You can't find zip archive in zip archive.
- You can't use special find.
- Shared workbooks are not target.


[Check]
- You can check find or replace before you execute on actual Excel workbook.
- At find, match part is colored red in "Result".
- At replace, if success replace, whole string after replace is colored red.
- You can use "Cross lines" at find only.
- On "F" button, formula and on "V" button, value of current cell is set on
  "Object string"


[Make]
- It makes regular expression that will replace with back reference.
- Input strings before replace in "Object string".
  Input strings that add at replace in "Add1-4".
  Input strings that is included in "Object string" in "Ext1-4".
  For example: In case of you replace "20110506" to "2011/05/06"
               "Object string": 20110506
               "Ext1"         : 2011
               "Add2"         : /
               "Ext2"         : 05
               "Add3"         : /
               "Ext2"         : 06
- On "Make" button, make "Find what" and "Replace with".
  For previous example:
  "Find what"   : ^(.{4})(.{2})(.{2})$
  "Replace with": $1/$2/$3
- On "Input" button, select "Replace" tab, and set "Find what" and "Replace with".


[Share]
- On "Extend" button, recieve useful and general-purpose regular expressions from the server,
  display list of them.
  Or, the list will be able to download as file from the server.
  If you check "Use local share data", reading from the file and display list.
- On "Input" button at "Share Data" window, selected regular expression is set 
  on main window.


[Assistant function]
- If you check "Open VBE at close", open and close VBE, and terminate Excel
  at Excel close. It is avoidance of error that if you use ManicTime and you
  close Excel, VBE prompt is displayed several times.
- By "Key change", you can set shortcut keys of find and replace dialog.
- By "Find clear", you can intialize find history.
- By "Replace clear", you can intialize replace history.
- If you use Excel 2000 over, you can do "Word complement".
  Save words inputted in "Find what" or "Additional cond" or "Replace with"
  combobox in the dictionary file (dic.txt in the add-in folder).
  When you input in previous comboboxes and stop during 750 milli-seconds,
  display max 10 prospective words from dictionary file.
  On "Dictionary" button, open the dictionary file.
- If you check "Quick search toolbar", toolbar for find is shown.
  You can find by current settings without using dialog.
- If you check "Decoration", decoration sub window is shown.
  At "Find", "Replace", "Shape", "Extract", "Grep", "Grep replace", and "Grep shapes" 
  tabs you can use it.
- If you check "Additional condition", additional condition sub window is shown.
  At "Find", "Replace", "Extract", "Grep", and "Grep replace" tabs you can use it.
- If you check "target shape", target shape sub window is shown.
  At "Shape" and "Grep shapes" tabs you can use it.
- If you check "Grep", grep sub window is shown.
  At "Grep", "Grep replace" and "Grep shapes" tabs you can use it.
- If you check "Addtional command", additional command sub window is shown.
  At "Find" and "Replace" tabs you can use it.
- These sub windows are shown if you move mouse cursor right next to main window.
  If you return mouse cursor to main window, sub windows are not shown.
  If you check "Always show", sub windows are remained.


[Worksheet function]
You can use worksheet function with regular expression.
These are listed in "Regular Expression Find" in "Insert Function" dialog.
But if the others open the workbook and this add-in isn't registerd in others' Excel,
others don't use these function. So after excute, you may delete these function by
paste value.
You can't use special find and special replace.

- RETEST(text,search_criteria)
  Test if match pattern. Distinct from upper case and lower case.
  Inspect if "text" is match for "search_criteria" (pattern), and if match,
  then returns True, unless False.

- REEXE(text,search_criteria,index)
  Returns match part for pattern. Distinct from upper case and lower case.
  If "text" is match for "search_criteria" (pattern), returns "index"-th
  part of match.
  If you omit "index", then returns 1st part.

- REEXE2(text,search_criteria,sub_match,index)
  Returns submatch (part between parentheses, at replace corresponding to $1 etc.) 
  of match part for pattern. Distinct from upper case and lower case.
  If "text" is match for "search_criteria" (pattern), returns "submatch"-th
  submatch of "index"-th part of match.
  If you omit "index", then returns 1st part.

- RECNT(text,search_criteria)
  Returns count of match part for pattern. Distinct from upper case and lower case.
  If "text" is match for "search_criteria" (pattern), then returns count of match
  part, unless returns 0.

- REREPL(text,search_criteria,replace_text)
  Returns string after replace. Distinct from upper case and lower case.
  If "text" is match for "search_criteria" (pattern), then returns "text"
  that was replaced "search_criteria" into "replace_text", unless "text" as is.

- RESPLIT(text,split_criteria,index)
  splits "text" with "split_criteria" (pattern) as delimiter, returns "index"-th.
  Distinct from upper case and lower case.
  If you omit "index", then returns 1st.

- RECNTIF(table,search_criteria)
  Returns count of cells that match for "search_criteria" (pattern) in "table"
  except blank cells. Distinct from upper case and lower case.
  This function is regular expressionable version of "COUNTIF".

- REVLOOKUP(search_criteria,table,column_number)
  Searches left end column from top in "table" with "search_criteria" (pattern),
  returns "column_number"-th cell of same row in "table" as first match.
  This function is regular expressionable version of "VLOOKUP".

- REHLOOKUP(search_criteria,table,row_number)
  Searches top row from left end in "table" with "search_criteria" (pattern),
  returns "row_number"-th cell of same column in "table" as first match.
  This function is regular expressionable version of "HLOOKUP".

- REMATCH(search_criteria,table)
  If column count in "table" is 1, then from top cell in "table",
  if row count in "table" is 1, then from left end cell in "table",
  searches with "search_criteria" (pattern) , and returns index in "table" of
  first match cell.
  If "table" is multiple columns and multiple rows, find result is none.
  This function is regular expressionable version of "MATCH".

- RERND(generate_criteria)
  Generate random string that matches with "generate_criteria" (pattern).
  Usable regular expression is following.
  [xyz], \w, \d, ., {x}, |, (), *, +, ?
  ("." is half-width alphanumeric characters only.)
  (Repeat times of "*" and "+" is to 5 times.)


[Regular Expression]
Uses RegExp object in VBScript as regular expression engine.
You can insert them input assistance of right click.

Position matching
^         match for top
$         match for last
\b        match for word boundary
\B        match for not word boundary

Literal
\n        match for new line
\f        match for form feed
\r        match for carriage return
\t        match for horizontal tab
\v        match for vertical tab
\?        match for ?
\*        match for *
\+        match for +
\.        match for .
\|        match for |
\{        match for {
\}        match for }
\\        match for \
\[        match for [
\]        match for ]
\(        match for (
\)        match for )
\xxx      match for ascii character expressed by oct xxx
\xdd      match for ascii character expressed by hex dd
\uxxxx    match for ascii character expressed by unicode xxxx
$$        $ (replace)

Character class
[xyz]     match for any one character included in character set
[^xyz]    match for any one character not included in character set
.         match for any one character except \n
\w        match for any one character used as word. equals [a-zA-Z_0-9].
\W        match for any one character not used as word. equals [^a-zA-Z_0-9].
\d        match for any one numeric character. equals [0-9].
\D        match for any one not numeric character. equals [^0-9].
\s        match for any one space character. equals [ \t\r\n\v\f].
\S        match for any one not space character. equals [^ \t\r\n\v\f].

Repeat
{x}       match for character just x before
{x,}      match for character more than x before
{x,y}     match for character more than x and less than y before
?         match for character 0 or 1 before. equals {0,1}.
*         match for character more than 0 before. equals {0,}.
+         match for character more than 1 before. equals {1,}.
?         (after repeat) shortest match


Selection and grouping
|         selection. integrate multiple phrase, and match for any these phrase.
()        make 1 phrase, grouping multiple phrase
(?:)      gropuing without back reference
(?=)      after match. match for if continue after.
(?!)      after not match. match for unless continue after.
(?<=)     before match. match for if exists before.
(?<!)     before not match. match for unless exists before.
(?#)      comment
\Q\E      qoute meta character

Special find
[COND>]x  find more than x
[COND<]x  find less than x
[COND>=]x find more than or equal x
[COND<=]x find less than or equal x

Back reference
\n        refers phrase between n-th parentheses (find)
$n        refers phrase between n-th parentheses (replace)
$&        refers match part for whole pattern (replace)
$`        refers previous part of match (replace)
$'        refers following part of match (replace)
$+        refers phrase between last parentheses (replace)
$_        refers whole input string (replace)

Special replace
[UPPER]   converts upper case
[LOWER]   converts lower case
[WIDE]    converts full size
[NARROW]  converts half size

Page setup
&L        Left
&C        Center
&R        Right
&E        Double underline
&X        Superscript
&Y        Subscript
&B        Bold
&I        Italic
&U        Underline
&S        Strikethrough
&D        Date
&T        Time
&Z        Path
&F        File name
&A        Sheet name
&P        Page No
&P+n      Page No (+n)
&P-n      Page No (-n)
&&        &
&"Font"   Font
&n        Font size (n)
&N        All page No


[Regexp Assemble]
- If you click current tab, turn into Regexp Assemble mode.
  You can assemble regexp pattern from multiple patterns.
- If you want to use this function in VBA, execute "NewRA" function,
  and you can generate Regexp Assemble Object.
  This object has "Add" method and "Re" method.
  Add:Add pattern
  Re:Return integrated pattern assembled from added patterns

  For example
  -------------------------------------------------
    Sub test1()

      Dim RA As Object

      Set RA = Application.Run("Excelre.xla!NewRA")

      RA.Add ("ABC")
      RA.Add ("BBC")
      MsgBox RA.RE

      Set RA = Nothing

    End Sub
  -------------------------------------------------
    Execute this, "[AB]BC" is out.


[Error report]
If error occurs, dialog that you may or not send error report opens.
If youb select OK, then sends error report to server (secedit.pekori.jp).
Personal information is not sent. After that, inquires that you may send
the Excel workbook, and if you OK, then sends the workbook to the server.
Collected information is used for only bug fix.
If you are OK with cooperation, please send.
If you check "Not send error report" in "Setting" tab, dialog that you may
or not send doesn't open.


[Exemption from responsibility]
- I don't owe responsibilty for any trouble that occurs by using this software.
  Use at your own risk.
- I'll welcome demand of improvement and bug report. But I don't know if I can
  do them technically or as policy. Though I can, I don't know that I can soon.


[History]
2015/09/17  Version 2.82
- Decoration search in cells gets faster.
- Enhanced usability at Excel 2013.
- Fixed error about sub windows at Excel 2013.

2015/08/16  Version 2.81
- Fixed error that replace all sometimes doesn't finish.

2015/08/02  Version 2.80
- Fixed small bugs.

2015/07/25  Version 2.79
- Added VBE tab.
- Deleted regular expression send function.
- Fixed other small bugs.

2015/06/27  Version 2.78
- Changed that VBA can use function of Regexp Assemble.
- Fixed error grep doesn't work in Excel 2000.
- Fixed other small bugs.

2015/06/21  Version 2.77
- Added function of Regexp Assemble.
- Modified other small things.
- Fixed other small bugs.

2015/04/06  Version 2.76
- Fixed error that can't open dialog in Excel 2013.

2015/04/05  Version 2.75
- Added password list to Grep sub window.
- Fixed error that freeze if you open file with password at Excel 2013 start.

2015/03/01  Version 2.74
- Enhanced usability of sub windows.
- Enhanced accuracy of find examples and RERND worksheet function.
- Modified that shapes without text is target in shape tab.
- Added additional command sub window to shape tab.
- Added "command reference" button to additional command subwindow.
- Added "color reference" button to additional command subwindow.
- Added "net all off" option.
- Modified "Open VBE at close" option.
- Modified other small things.
- Fixed other small bugs.

2015/02/14  Version 2.73
- Additional command sub window is added.
- Fixed error that sometimes occurs by formula error in replace.
- Fixed error that occurs by formula error in making result list.

2015/02/01  Version 2.72
- Mini window mode 2 is added.
- "Current Cell (Formula)" is added to right click menu.
- "Current Cell (Value)" is added to right click menu.
- "Delete from List" is added to right click menu.
- Modified other small things.
- Fixed error that process sometimes doesn't finish when use standard find.
- Fixed error that sometimes drops find target when use standard find.
- Fixed error that target area is small when marged cells are selected
  in whole workbook find.
- Fixed error that occurs in case refers cells whose formula can't be refered
  when use standard find.
- Fixed error that occurs in case columns are too many in high speed value grep.
- Fixed error that occurs in case select hidden comment in shape process.
- Fixed error that occurs in case open worksheets which can't be opened
  in high speed value grep.
- Fixed error that occurs in case search result is none in whole workbook find
  or whole workbook replace.
- Fixed other small bugs.

2015/01/01  Version 2.71
- Adapted to replacing array formula.
- Adapted worksheet functions to array formula.
- Improved display of minimap in Excel 2013.
- Improved display of windows in Excel 2013.
- Added name tab.
- Function of "Save replace patterns" is added.
- Option of "remember window position" is added.
- Option of "window animation off" is added.
- Update button for version up is added.
- Sub window show button is added.
- Modified that can operate sub window with keyboard.
- Added key tab in setting tab.
- Modified setting current cell when minimap is shown.
- Modified other small things.
- Fixed error that worksheet functions maybe don't work except in Japan.
- Fixed error that sub windows don't work depending on environments.
- Fixed error that sub windows don't work in trial mode.
- Fixed error that sometimes don't start up if sub windows are always shown.
- Fixed error that grep sometimes stops.
- Fixed error that error sometimes occurs at shape grep of idle execution.
- Fixed error that idle execution grep stops.
- Fixed other small bugs.

2014/12/14  Version 2.70
- Mini window mode is added.
- High speed grep is stabilized.
- Fixed other small bugs.

2014/12/10  Version 2.69
- High speed value search in grep is added.
- Fixed error that high speed grep doesn't work.
- Fixed error that background grep doesn't work.
- Fixed error that idle time grep stops.
- Fixed error that sometimes aborts by overflow at value search.
- Fixed error of sub window display.

2014/09/21  Version 2.68
- Fixed error that extract doesn't work correctly.

2014/07/07  Version 2.67
- Added decoration sub window to extract tab.
- Added additional condition sub window to extract tab.
- Added display of result list to shape find.
- Modified other small things.
- Fixed other small bugs.

2014/06/26  Version 2.66
- Changed way to show sub windows.
- Modified other small things.
- Fixed other small bugs.

2014/06/01  Version 2.65
- Fixed error that can't install in Excel 2000.
- Fixed error that high speed mode of grep doesn't work just after install.

2014/05/26  Version 2.64
- Fixed error that high speed mode of grep doesn't work sometimes.
- Modified that can't use mouse gesture in 64 bit Excel.
- Added display of progress rate at grep progress.
- Fixed other small bugs.

2014/05/21  Version 2.63
- Added high speed mode of shape grep.
- Added high speed mode of shape grep replace.
- Modified that can use high speed mode only by multi core CPU.
- Fixed error that worksheet function of REREPL doesn't work in 64 bit Excel.

2014/05/18  Version 2.62
- Added high speed mode of grep replace.
- Added grep progress option.
- Fixed error that doesn't work in Excel 2000.
- Fixed error of standard find.

2014/05/12  Version 2.61
- Fixed error of high speed mode of grep.

2014/05/10  Version 2.60
- Added high speed mode of grep.
- Added "Include Smartart" option in shape.
- Fixed error of standard find.

2014/04/13  Version 2.59
- Fixed error that isn't found sometimes at standard find.

2014/03/30  Version 2.58
- Added process of next start after abort.
- Added "before match" and "before not match" to worksheet function.
- Window process got lighter.
- Changed way to install.

2014/03/09  Version 2.57
- Fixed error that can't find date type data at standard find.
- Fixed error that can't restore group when same name shapes exist.

2014/02/10  Version 2.56
- Process speed gets faster.
- Modified small things.

2014/02/01  Version 2.55
- Fixed error that sometimes occurs in standard find.
- Fixed error that occurs when accesses worksheets that can't be accessed.

2014/01/26  Version 2.54
- Fixed error that can't find in multiple worksheets by standard find.

2014/01/03  Version 2.53
- Changed that mouse gestures aren't accepted during processing.
- Changed that "^" and "$" in "\Q\E" phrase work.

2013/12/23  Version 2.52
- Outline function is added.
- Minimap is adjusted a little.
- Fixed error that select all when not using standard find doesn't work correctly.
- Fixed error that sometimes doesn't hit in standard find.

2013/12/15  Version 2.51
- Minimap function is added.
- Starting command is added to right click menu of page break preview.

2013/11/30  Version 2.50
- The literal $ in right click menu is added.
- Fixed error that can't get news.

2013/11/14  Version 2.49
- Grep sub window is added.
- Function of executing grep in background is added.
- Fixed error that occurs at check with cross lines.

2013/11/08  Version 2.48
- Fixed error that can't do grep.

2013/11/05  Version 2.47
- Added row select and column select on select all.
- Added bookmark function.
- Added news display function. (Japanese news only)

2013/07/27  Version 2.46
- Modified small things.
- Fixed small bugs.

2013/07/13  Version 2.45
- Added mouse gesture function.

2013/06/30  Version 2.44
- Fixed small bugs.

2013/06/01  Version 2.43
- Added "Exec at idle time" option in grep.
- Fixed error that at right click menu of tab "Default" Excel sometimes aborts.
- Fixed error that in case same name shapes exist, select all doesn't work correctly.

2013/05/12  Version 2.42
- Added select all in shape tab.
- Modified that can do multiple sheets at find all and replace all in shape tab.
- Added offset function of grep.
- Fixed error that can't stop at standard find in grep.
- Fixed error that autofilter hidden cells aren't found at standard find in grep.
- Fixed error that cells out of selection aren't found at standard find in grep.
- Modified other small things.
- Fixed other small bugs.

2013/05/06  Version 2.41
- Fixed error that "confirm when replace" of standard find doesn't work correctly.
- Fixed error that can't operate after cancel of "confirm when replace".
- Fixed error of shortcut key action in 64 bit Excel.

2013/05/06  Version 2.40
- Added function of select all in find tab.
- Fixed error that find all of standard find doesn't work correctly.
- Modified other small things.

2013/05/03  Version 2.39
- Fixed error that search direction of standard find is opposite.
- Fixed error that occurs when error cell is found in value search of standard find.

2013/04/29  Version 2.38
- Modified that if can find by standard find, use standard find.
- Added option of not using standard find.
- Fixed error that occurs by referring overflowed cells.

2013/04/02  Version 2.37
- Added functions to right click menu of tab.
- Enhanced precision with auto update.
- Fixed other small bugs.
- Modified other small things.

2013/01/26  Version 2.36
- Fixed error that sub forms don't act in Windows XP.
- Added function of auto clear.
- Fixed error that function of IME re-convert don't act.
- Modified that can IME re-convert in English characters.
- Ordered item in setting tab.
- Fixed error that sometimes doesn't replace correctly at special replace.
- Modified other small things.

2013/01/16  Version 2.35
- Added function of displaying search result example.
- Added function of parentheses complement.
- Added usable regular expression of RERND function.
- Fixed error that sometimes doesn't replace correctly at special replace.
- Fixed other small bugs.

2013/01/03  Version 2.34
- Changed decoration form.
- Added additional condition form.
- Added target shape form.
- Changed way of display sub forms.
- Added function of decoration change in find, replace, and grep replace.
- Added function of decoration change in shape, shape replace, and shape grep replace.
- Added function of additional condition in grep and grep replace.
- Added function of target shape in shape grep and shape grep replace.
- Fixed error that search doesn't finish in case of search pattern error at sequencial search.
- Fixed error that that can't close form if error occurs in shape grep replace.

2012/12/15  Version 2.33
- Changed font of English mode.
- Fixed error that occurs when formula is hidden.
- Fixed error that aborts in trying.
- Fixed other small bugs.

2012/12/02  Version 2.32
- Changed way of display decoration form.
- "Keep color" is changed into "Keep decoration".
- Decoration search function is added at replace and grep replace.
- Added find in sequence.
- Process speed gets faster.
- Fixed error that aborts when right click menu in Excel 2013 Preview.
- Fixed error that sometimes drops find target when cells over max formula letters exist.
- Fixed error that occurs when replace with keep color for formula error cell.
- Fixed error that occurs when find underline in decoration.
- Fixed other small bugs.

2012/11/21  Version 2.31
- Added option of change tab order.
- Added right click menu of tab.
- Added preview function in split tab.
- Modified error that occurs when do extract in shared workbook.
- Modified error that occurs when do shape grep or shape grep replace in shared workbook.

2012/10/28  Version 2.30
- Added split tab.
- Added Start pos button on find and replace tab.
- Modified that can stop process during find all and replace all.
- Find all get faster.
- Coloring process at find and replace get faster.
- Modified other small bugs.

2012/09/23  Version 2.29
- Added function of quick search toolbar.
- Added option of grep history off.
- Modified that ignore books with password at grep system.
- Modified other small bugs.

2012/09/09  Version 2.28
- Modified that can use minimize button after find all.
- Added option that targets opened files at grep system.
- Modified error that sometimes occurs at decoration color find over Excel 2007.
- Modified error of worksheet function "RERND".

2012/08/12  Version 2.27
- Worksheet function "RERND" is added.

2012/07/21  Version 2.26
- Changed that at grep or shape grep you can find in zip archives.
- Modified other small bugs.

2012/07/20  Version 2.25
- Adapted to Excel 2013 Preview.
- Changed that if install with admin authority, display notice.

2012/07/15  Version 2.24
- Folder input area is changed to combobox.
- Changed that input folder is selected at folder select dialog.
- Function of rename is added.

2012/05/20  Version 2.23
- Function of delete tool bar setting file is added.

2012/04/15  Version 2.22
- Function of auto dialog position adjustment after find is added.
- Modified error that sometimes occurs in shape replace.
- Modified error that sometimes occurs in sheet replace.
- Modified error that selection in from result 2 to result 10 
  of find all list doesn't work.

2012/04/07  Version 2.21
- Search direction option is added.
- Find all and replace all get faster.

2012/03/31  Version 2.20
- Setting Tab is added.
- Meiryo UI Option is added.
- Modified error that Japanese remains partly in English mode.
- Modified that when opened readonly in grep replace or shape grep replace,
  colors red in result list.
- Modified that opens readonly at shape grep.
- Save judgment at grep replace or shape grep replace became stricter.

2012/03/24  Version 2.19
- Function of IME re-convert by convert key is added.
- Modified error that sometimes occurs in find with coloring and cross lines.
- Modified error that occurs by workbook without worksheets at grep or grep replace.

2012/03/10  Version 2.18
- Modified error that sometimes occurs in shape system when undo groups.
- Enhanced precision with check of folder existence in grep system.
- Modified that can't close form during process in grep system.

2012/02/19  Version 2.17
- Function of replace select is added.
- Modified that doesn't target Excel temp file at grep system.
- Modified error that is judged trial mode when isn't trial mode.

2012/02/08  Version 2.16
- Modified that can keep to 10 results of "Find all".
- Changed process of undo function.

2012/02/05  Version 2.15
- Modified that don't check if object string is empty at check.
- Tool hint about back reference is added.
- Modified other small things.

2012/01/03  Version 2.14
- Decoration find function is added.
- Sheet tab is added.
- Modified other small bugs.

2011/12/10  Version 2.13
- Trial mode is added.
- Phrase "\Q\E" (quote meta character) is added.
- Modified "Open VBE at close" option.

2011/12/03  Version 2.12
- "Open VBE at close" option is added.
- Modified error that aborts when do shape replace at Excel 2007 over.
- Modified error that aborts when do shape grep replace at Excel 2007 over.
- Modified error that can't do set of normal find and special find at additional cond.
- Modified error that can't change color of numeric cells at coloring.

2011/11/27  Version 2.11
- Phrase "(?<=)" (before match) is added.
- Phrase "(?<!)" (before not match) is added.
- Modified error that aborts when try to terminate Excel and cancel.
- Modified error that special replace doesn't run at shape replace.
- Modified error that doesn't run in English version environment.

2011/11/19  Version 2.10
- English mode is added.

2011/10/22  Version 2.09
- Modified error that occasionally aborts when terminate Excel at Excel 2000.
- Modified error that replace doesn't finish when replace top or last with 
  "Keep color".
- Modified error that replace doesn't finish when replace top or last in shape
  with "Keep color".
- Modified error that doesn't run right click menu for example "Cut" after Vista.

2011/09/19  Version 2.08
- Modified that ignores dialog of link to other workbook when Grep system.
- Modified error that find doesn't finish occasionally when hiding columns.

2011/08/14  Version 2.07
- Modified error that occasionally occurs at "Find all" including graph sheets.

2011/08/05  Version 2.06
- Adjusts form after "All find" at Aero theme.
- Modified error that occasionally occurs when find with coloring or replace
  after can't replace because of formula error.
- Modified error that occurs when merged cells are in "Column to" at extract.

2011/07/29  Version 2.05
- Worksheet function "REMATCH" is added.
- Function guide is added.

2011/07/18  Version 2.04
- Modified error that don't open if diagram draw toolbar is hide at Excel 2003 SP3.
- "Not undo" option of find with coloring is added.
- Find with coloring gets faster.
- Replace with "Keep color" gets faster.

2011/07/11  Version 2.03
- Modified error of auto install.
- Modified action when turn on or off add-in temporary.
- Worksheet function "REVLOOKUP" is added.
- Worksheet function "REHLOOKUP" is added.
- Step of connecting server function is added when server is busy.
- Modified other small bugs.

2011/06/21  Version 2.02
- Strengthen error report function.

2011/06/08  Version 2.01
- "Confirm when replace" option at shape replace is added.
- Modified that keeps color before replace at shape replace.
- Modified that opens confirm dialog at Grep replace and shape Grep replace.
- "Keep color" option at replace is added.
- Modified that if "Keep color", undo after replace undoes character color too.
- Modified that undoes groups after release groups at shape find and shape replace.
- Modified that undoes groups after release groups at shape grep replace.
- Modified error that shows notice message if could replace all at shape grep.

2011/05/08  Version 2.00
- Function of make regular expression is added.
- Description of frequently used regular expression is added.
- "Object" option at shape find and shape replace is added.
- Modified error that occurs formula error is in "Column from" at extract.
- Modified error that doesn't save settings at Excel 2000.
- Modified error that aborts when unistall if open multiple Excels.
- Modified error that can use function of internal process.
- Modified other small things.

2011/05/01  Version 1.99
- Modified error that occurs after find with corling formula cells.
- Modified that can undo after spcial find with coloring.
- Modified error that aborts when do shape find or shape replace in shared workbook.
- Modified error that aborts when do shape grep or shape grep replace in shared workbook.

2011/04/27  Version 1.98
- Modified error that aborts if hide worksheet is in workbook at shape grep.
- Modified that can set on or off checking update at start up.
- Modified that can set on or off function using internet at first start up.

2011/02/13  Version 1.97
- Modified error that not distinct half/full size, upper/lower case at spcail find etc.

2011/01/23  Version 1.96
- Modified error that don't open if diagram draw toolbar is hide at Excel 2003 SP3.

2011/01/02  Version 1.95
- Modified that changes color of replace part at shape replace.
- Modified error that Excel isn't active at Excel open.

2010/12/15  Version 1.94
- Function of half clear form is added.
- Function of selection of form background color is added.
- Modified error that doesn't replace correctly at "Replace prev" with find value.
- Modified error that occurs if will be formula error after replace with find value.

2010/11/28  Version 1.93
- Modified that changes checking update at startup from when open form to when open Excel.
- Modified error that doesn't display right click menu at "Word complement".
- Function of undo when find with coloring is added.

2010/11/21  Version 1.92
- Modified error that aborts or errs after failed undo.
- Abolished function that displays advertisement.
- Function of auto update is added.

2010/11/14  Version 1.91
- Modified error that occurs when find with "Cross lines" and "Coloring".
- Modified that can do auto install if don't have authority of common add-in folder.
- Modified that can use function in insert function dialog at 64 bit Excel too.
- Function that displays advertisement is added.

2010/11/06  Version 1.90
- Function of sharing regular expression is added.
- Modified other small things.

2010/11/01  Version 1.86
- Open from right click menu is added.
- Modified error related to graph sheets.
- Modified error that "Find value" option isn't effective.
- Modified error that replace doesn't finish if shapes refering cell exist at shape replace.
- Special find is added.
- Modified error that aborts if protected worksheets exist.
- Shape grep replace is added.
- Modified other small things.

2010/10/11  Version 1.85
- Modified that targets files whose extension are upper case at grep.
- Modified error that targets files whose name include ".xls" too at grep.
- Modified error that occurs when find with coloring of 256 over match characters.

2010/09/20  Version 1.84
- Modified error that aborts when path is 260 over characters at grep.

2010/07/15  Version 1.83
- Modified that can run in 64 bit Excel.

2010/06/06  Version 1.82
- Shape grep is added.

2010/05/09  Version 1.81
- Phrase "(?#)" (comment) is added.
- Modified error that aborts Excel if complement words is none at "Word complement".

2010/05/04  Version 1.80
- "Word complement"is added.
- Function of "Save patterns" is added.

2010/04/25  Version 1.78
- Modified error that occurs when find with coloring in cells of max formula characters.
- Modified that changes new line at replace from CRLF to Excel standard LF.

2010/02/11  Version 1.77
- Modified error that occurs if select "No" at confirmation of replace.

2010/01/14  Version 1.76
- Modified error that occurs when find or replace selecting objects.
- Modified error that aborts when select list after "Find all" if workbooks or worksheets
  don't exist.
- Modified error that occurs when find with coloring in protected worksheets.
- Modified error that aborts when do grep replace in protected worksheets.
- Modified error that occurs when do "Special find".
- Modified error that occurs when get formula error after replace.

2010/01/02  Version 1.75
- Function of checking regular expression is added.
- Modified error that occurs when get formula error after replace.
- Modified other small bugs.

2009/12/20  Version 1.74
- Changes font of input area to MS Gothic.
- Checking update gets faster. 
- "Set current cell on ""find what"" at start up" option is added.
- Function of undo after replace error is added.
- Modified error that don't move tabs by Ctrl+PageUp or PageDown depending on environments.
- Modified error that occurs when hits formula error cell at find.

2009/12/15  Version 1.73
- Modified that doesn't abort when error occurs.
- Error report is added.

2009/12/09  Version 1.72
- "Cross lines" at find is added.
- Modified error that aborts when find formula cell with coloring at find and extarct.
- Modified small bugs of extarct.
- Modified error that isn't distinct from upper case and lower case 
  in worksheet function.

2009/08/15  Version 1.71
- Modified error in customize of shortcut key of dialog open.

2009/07/18  Version 1.70
- "Additional cond" is added in find and replace.
- Deleted find button from "Replace" tab.
- Modified other small things.

2009/06/28  Version 1.60
- Modified error that item in grep result list doubles.
- Grep replace is added.

2009/06/21  Version 1.52
- Incremental search is added.

2009/05/10  Version 1.51
- Modified that can change size of dialog after "Find all".

2009/03/05  Version 1.50
- Modified error that extract doesn't run correctly when use auto filter.

2009/02/24  Version 1.49
- Modified error that aborts if formula error cells exist.

2009/01/20  Version 1.48
- Modified error that doesn't store history in shape replace combobox.

2008/07/08  Version 1.47
- Worksheet function "RESPLIT" is added.

2008/06/03  Version 1.46
- "Coloring" option is added in find and extract.

2008/02/15  Version 1.45
- Modified error that doesn't find A1 cell in first worksheet at grep.
- Modified error that doesn't find hide cell by auto filter at grep.

2008/02/04  Version 1.44
- Worksheet function "REEXE2" is added.
- Items of input assistance are added.
- Modified regulae expression section in readme.

2007/12/19  Version 1.43
- Worksheet function "RECNTIF" is added.

2007/12/09  Version 1.42
- Special replace is added.
- Right click menu is added in shape replace combobox.

2007/10/11  Version 1.41
- Modified error that doesn't run if first character in "Replace with" is "\n".

2007/08/21  Version 1.40
- Shape replace is added.

2007/08/12  Version 1.37
- Worksheet function "RECNT" is added.
- Description of parameter in insert function dialog is added.

2007/06/21  Version 1.36
- Modified error that doesn't run if paste new line in "Find what".

2007/06/10  Version 1.35
- Modified error that doesn't find correctly sometimes if merged cells are in worksheet.
- Items of input assistance are added.
- Modified regulae expression section in readme.

2007/06/01  Version 1.34
- Right click menu in input area is added.
- Input assistant for regular expression input is added.
- Manual install is added.

2007/05/26  Version 1.33
- Modified error that aborts when cells of over max formula characters exist.

2007/05/10  Version 1.32
- Modified error that aborts when cells of over max formula characters exist.
- Modified error that sometimes doesn't find in first column at "Find prev" or
  in max column at "Find next".
- Modified error that see part of form after "Find all" depending on environments.

2007/04/21  Version 1.31
- Modified error that doesn't find correctly if blank cell isn't judged as blank cell.
- Modified error that doesn't finish find depending on inputted cell and blank cell. 

2007/04/17  Version 1.30
- Shape find is added.

2007/04/08  Version 1.20
- Grep is added.
- "\n" at replace is added.
- Modified error that aborts if formula error cells exist at find value.

2007/03/11  Version 1.13
- Changed save add-in in from user add-in folder to common add-in folder
  in Excel 2000 over.

2007/03/06  Version 1.12
- Modified error that can't run in Excel 97.

2007/02/26  Version 1.11
- Modified that can run in Excel 2007.
- "Confirm when replace" is added.
- Function of history clear is added.
- Find gets faster.

2007/02/02  Version 1.10
- Worksheet functions are added.
- Extract is added.
- Undo at replace is added.
- Checking update is added.
- Modified error that doesn't finsh find if select area of no match cell.
- Modified error that "Only string values" doesn't run.
- Modified error that aborts when push find button with no active workbook.
- Modified error that can't open if user add-in folder is got by short path.
- Modified error that focus is nowhere when input error occurs.
- Modified error that can use function of internal process.

2007/01/23  Version 1.00
- New publication.
