Soon to be released: version 4.2.9

Text » Replace accented characters (á, ë, ñ etc.)...While I'm working on the next big updated version (4.3), a few people have found some bugs in version 4.2.8 that I've now fixed in version 4.2.9. More information and download of the pre-release: //www.asap-utilities.com/faq-questions-answers-detail.php?m=195 This version will probably be officially released next Thursday.

Prepare a document before sending it to others

When you send your Excel workbook to other people, sometimes you want to protect or hide certain parts. For example the formulas you used or temporary data in hidden columns. You can do this by using Excel's worksheet protection, however you should know that this protection is easily broken and not very secure. A better method to use ...

Weird looping through cells in a range object

Below is something that I experienced a while ago and was beyond my logic. Setting a range and looping through all cells in it didn't work initially as expected. Sub WeirdCelLooping()      Dim rngCel                                       As Range      Dim rngSelection                                 As Range      Range("A1:G10").Select      ' Doesn't work correctly:      For Each rngCel In Selection.Columns(1)            ' both rngCel and the selection have now the same address            Debug.Print rngCel.Address & " ...

Now available: ASAP Utilities 4.2.8

Delete all objects in selected worksheetsYesterday the new version of ASAP Utilities was officially released. You can read the details in the newsletter or you can immediately proceed to the download page. Besides several bugfixes, these are two new things: Objects & Comments » Delete all objects on current worksheetThis utility can now be used on multiple worksheets and has been renamed ...