Excel FAQ

A collection of the most frequently asked questions in the Excel/VBA forum. Check in Here Before Posting

    1. Extact nth Word from Text. Custom Function

      • Dave Hawley
    2. Replies
      0
      Views
      2.9k
    1. Extract Specific Words From a Text String

      • Dave Hawley
    2. Replies
      0
      Views
      5.8k
    1. Convert Formula References. Relative/Absolute

      • Dave Hawley
    2. Replies
      0
      Views
      8.1k
    1. Validating UserForm TextBox to Only Accept Numbers

      • Dave Hawley
    2. Replies
      0
      Views
      4.5k
    1. Protect and Unprotect All Worksheets

      • Dave Hawley
    2. Replies
      0
      Views
      8k
    1. Subtotals

      • Dave Hawley
    2. Replies
      0
      Views
      3k
    1. Count Words in a Cell or Range of Cells

      • Dave Hawley
    2. Replies
      0
      Views
      4.6k
    1. Save a Workbook as the Text in a Cell

      • Dave Hawley
    2. Replies
      0
      Views
      4.3k
    1. Return Worksheet Name to a Cell

      • Dave Hawley
    2. Replies
      0
      Views
      5.4k
    1. Count of Items in List VBA

      • Dave Hawley
    2. Replies
      0
      Views
      5.6k
    1. Count of Each Item in a List

      • Dave Hawley
    2. Replies
      0
      Views
      4.4k
    1. Convert Formula References

      • Dave Hawley
    2. Replies
      0
      Views
      4.5k
    1. Alternate Row Coloring

      • Dave Hawley
    2. Replies
      0
      Views
      4.5k
    1. Stop/Prevent Duplicates

      • Dave Hawley
    2. Replies
      0
      Views
      4.3k
    1. Create Custom Menu Items with VBA

      • Dave Hawley
    2. Replies
      0
      Views
      8.3k
    1. Hide & Restore Toolbars in Excel VBA

      • Dave Hawley
    2. Replies
      0
      Views
      11k
    1. Data Validation

      • Dave Hawley
    2. Replies
      0
      Views
      4.4k
    1. Creating a Worksheet Index Sheet

      • Dave Hawley
    2. Replies
      0
      Views
      7.4k
    1. Lookup Left in Table

      • Dave Hawley
    2. Replies
      0
      Views
      6.2k
    1. Highlight Duplicates

      • Dave Hawley
    2. Replies
      0
      Views
      10k

Display Options