ASAP Utilities 4.5.2

ASAP Utilities 4.5.2 helps you filling the gaps in Excel and automates frequently used tasks. It contains over 300 functions to make your work easier and faster done.
Since 1999 it has grown to become probably one of the worlds most popular add-ins for MS Excel.

Major Features:

1. Improved to better reflect the possibility to create a custom separated text file, such as for example a pipe delimited file. If you specify a comma (,) as delimited, the file will be saved as a .csv file. If you specify a different delimiter you can use your own file extension.Save as a pipe (|) delimited text file
2. Bugs fixed
   • Didn't work to index charts, you then got the following error: "Sorry, something unexpected went wrong at code line 620: Type mismatch". This bug is now fixed.
   • idn't extract the hyperlinks from cells. This is now fixed.
   • If you choose the option "selected sheets" you got an error: "Sorry, something unexpected went wrong at code line 350: Object variable or With block variable not set". This bug is now fixed.
   • Produced an error when it tried to read any "Property Let" code. This is because it treated it as a procedure and wanted to count the number of code lines in it
   • The utility used to rely on Excel's method of detecting blank cells. However sometimes Excel doesn't recognize empty cells correctly and it thinks the empty cells are not empty. You can replicate this when the function =ISBLANK() returns false for an empty cell.
   • We have now fixed this by using our own method of detecting truly empty cells.
   • The utility used to rely on Excel's method of detecting blank cells. However sometimes Excel doesn't recognize empty cells correctly and it thinks the empty cells are not empty. You can replicate this when the function =ISBLANK() returns false for an empty cell.
   • We have now fixed this by using our own method of detecting truly empty cells.
   • This utilityt only counted the errors in cells with constants. Now it counts the errors in formula cells as well.
   •  Select » Select cells based on content, formatting and more...
   • If you had less then 20 cells and choose the option to select the duplicate or unique values, the utility produced an error: "Sorry, something unexpected went wrong at code line 880: show the progress bar, Error 11: Devision by zero".  This bug is now fixed.
   • The utility didn't work if you wanted to unprotect the selected sheets. In such a case you got an error message. This is now fixed. The option to unprotect all sheets worked without problems.
   • Fixed a bug when you got an incorrect warning to choose fewer columns or rows because ASAP Utilities thought the available amount of rows or columns in your worksheet was 0.
   • The utility was unable to remove hidden columns in an autofilter, because Excel cannot delete a column in an autofilter if it is hidden. If you had this then the utility produced an error: "Sorry, something unexpected went wrong: Delete method of Range class failed". This bug is now fixed. However if you use Excel 2000 and want to remove hidden columns you first have to turn off the autofilter. Removing hidden rows with autofilter turned on works in all Excel versions.
3.  General
   • A few people got the following question when they closed Excel: "Do you want to save the changes made to 'ASAP Utilities.xla'?". In theory that should not be possible because the file is opened as read-only and the program doesn't make any changes to it itself. But still, in practice, some people got this question. We've made a few changes to be sure that Excel doesn't ask this anymore.
   • Didn't work and gave an error message if you workbook contained other sheets than just worksheets. This is now fixed.
   • Didn't work and gave an error message if you workbook contained other sheets than just worksheets. This is now fixed.
     
   • If you used this on filtered data (such as in an autofilter) the utility put the calculation mode for your workbook to manual. This is now fixed, the utility puts the calculation state back into the state it was before the utility ran (as it was supposed to do).
   • When you used the file size toolbar and had it set to automatically update automatically every x seconds, you could get an error if you removed the toolbar manually without first turning the automatic update off.
     

Requirements:

• - Excel 2000, 2002/XP, 2003 or 2007