A bit off-topic but because working with shortcuts is often so much faster. I believe that shortcuts are are preferred when it comes to speed/productivity and reducing the chances on RSI. Microsoft: List of keyboard shortcuts for Word 2002, Word 2003, and Word 2007 http://support.microsoft.com/kb/290938 Just in case you weren't aware, we have a list of the shortcuts in ...

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.

Enno asked me the following: "... When I value-copy ranges where the If-function was used with a return value of "" (empty string), the cells are not blank, hence ISBLANK() = FALSE. Could you add a feature to remove empty strings? ..." Well, you can do this already with ASAP Utilities, although you cannot find it in the description of ...

I got the following question from Jonathan this week: ... Don't know if this can be done at the moment, perhaps you could advise... I have a range of cells and I want to select ALL the cells/rows in the selection where the value changes. I can select the first cell where the value changes using 'Select Cells' ...

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 & " ...

A short macro that will unhide all columns and rows in order to make all data visible again. Might be useful in some cases. Sub UnhideAllColumnsRows() ' unhide all columns and rows on the current worksheet Cells.EntireColumn.Hidden = False Cells.EntireRow.Hidden = False End Sub If you want more control on which rows and/or columns to unhide, you can also use this tool ...

Yesterday 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 ...

Jeff recently asked: I really like your product but just came upon a capability it is missing: Delete trailing spaces (but keep all other spaces). I expect it would be simple enough to add; would you? I never expected anyone to need a tool to only remove the trailing spaces but he needs it on imported ...

Max asked the following: Can the "Fill fill up with leading zero's" option under be made to work on leading or trailing zeros? For instance, if I have three numbers: 1 12 123 I would run the option to fill them with trailing zeros so they would look like: 1000 1200 1230 We want to normalize the numbers so they would all be ...… Read more... "Add trailing zeros"