Sub TestListFolders()         Application.ScreenUpdating = False          'create a new workbook for the folder list          ...

Here are the five most common errors I have found (and made) while programming in VBA. Most errors are as valid in Excel VBA as they are i...

Using conditional formatting to highlight dates in Excel.... Date functions in  Excel  make it is possible to perform date calculat...

  1. You can auto fit the width of column by  A) double clicking on the column name on column header  B) Double click on the cell poin...

Description VBA Code Selecting '==Select 3 rows down, 2 columns right: ActiveCell.Offset(3, 2).Select '==Select f...