Version 4.2.8 - September 23, 2008

Finished

On September 23, 2008 the new version 4.2.8 is released. Download

New/improved

• Objects & Comments » Delete all objects on current worksheet
  This utility can now be used on multiple worksheets and has been renamed to:
  Delete all objects in selected worksheets
  
• ASAP Utilities Options » Start the last used utility again...
  This now is the default 'repeat' action after a tool in ASAP Utilities has been used so that you can also use it from the Excel menu (Edit > Repeat) or with Excel's built-in shortcuts F4 or Control+Y.
  

Bugs fixed

• Range » Move selected range (only values)...
  Didn't work in Excel 2000. This is now fixed
  (Error 438: Object doesn't support this property or method)
• Objects & Comments » Delete all objects on current worksheet
  This utility also removed the comments on your sheet. However the "comment-indicators", the triangles, were still shown by Excel. It could happen then when you click on a cell to view the comment that Excel would crash.
  The utility has now been updated so that al objects, except the comments, are removed.
• Fill » Insert before current value...
  Didn't always work on very long cells. In such a case it could produce an error and ASAP Utilities stopped working and you had to restart Excel to get ASAP Utilities working again. This is now fixed.
• Web » Convert hyperlinks to =HYPERLINK() formulas
  Fixed the error that occurred when a cell in your selection contained a double quote ("). A few small improvements were made too.
• Range » Find / Replace in all sheets...
  Fixed a bug when you could get an error with certain cell with long contents.
  Furthermore the formulas in the results will now be displayed using your Excel's country settings instead of in the US/English notation.
• Text » Advanced character removal/replace...
  Fixed a bug when nothing was removed/replaced in certain cells with long contents.
• Columns & Rows » Conditional row and column select, hide or delete...
  The option 'every n'th row/column number' disappeared when you changed the option to handle 'rows' to 'columns'. This is now fixed.
• Range » Advanced sorting...
  Fix the bug that sometimes occurred during the startup of the utility and produced an error such as "Error 424: Object Required" or "Method '~' of object '~' failed, Error -2147221080: Automation error"
  This error could happen if you used the utility on a workbook, then closed that workbook and then used this sorting utility again.
• General
  A few spelling errors were corrected.