Excel FAQ
A collection of the most frequently asked questions in the Excel/VBA forum. Check in Here Before Posting
-
-
-
Extact nth Word from Text. Custom Function
- Dave Hawley
July 5, 2005 at 7:20 AM
- Dave Hawley
July 5, 2005 at 7:20 AM
-
- Replies
- 0
- Views
- 3.1k
-
-
-
-
Extract Specific Words From a Text String
- Dave Hawley
July 4, 2005 at 10:36 AM
- Dave Hawley
July 4, 2005 at 10:36 AM
-
- Replies
- 0
- Views
- 5.9k
-
-
-
-
Convert Formula References. Relative/Absolute
- Dave Hawley
June 30, 2005 at 5:35 AM
- Dave Hawley
June 30, 2005 at 5:35 AM
-
- Replies
- 0
- Views
- 8.3k
-
-
-
-
Validating UserForm TextBox to Only Accept Numbers
- Dave Hawley
June 30, 2005 at 5:33 AM
- Dave Hawley
June 30, 2005 at 5:33 AM
-
- Replies
- 0
- Views
- 4.7k
-
-
-
-
Protect and Unprotect All Worksheets
- Dave Hawley
June 30, 2005 at 5:32 AM
- Dave Hawley
June 30, 2005 at 5:32 AM
-
- Replies
- 0
- Views
- 8.2k
-
-
-
-
Subtotals
- Dave Hawley
June 30, 2005 at 5:31 AM
- Dave Hawley
June 30, 2005 at 5:31 AM
-
- Replies
- 0
- Views
- 3.1k
-
-
-
-
Count Words in a Cell or Range of Cells
- Dave Hawley
June 30, 2005 at 5:30 AM
- Dave Hawley
June 30, 2005 at 5:30 AM
-
- Replies
- 0
- Views
- 4.7k
-
-
-
-
Save a Workbook as the Text in a Cell
- Dave Hawley
June 28, 2005 at 9:03 AM
- Dave Hawley
June 28, 2005 at 9:03 AM
-
- Replies
- 0
- Views
- 4.4k
-
-
-
-
Return Worksheet Name to a Cell
- Dave Hawley
June 28, 2005 at 5:11 AM
- Dave Hawley
June 28, 2005 at 5:11 AM
-
- Replies
- 0
- Views
- 5.5k
-
-
-
-
Count of Items in List VBA
- Dave Hawley
June 26, 2005 at 11:52 AM
- Dave Hawley
June 26, 2005 at 11:52 AM
-
- Replies
- 0
- Views
- 5.7k
-
-
-
-
Count of Each Item in a List
- Dave Hawley
June 26, 2005 at 7:25 AM
- Dave Hawley
June 26, 2005 at 7:25 AM
-
- Replies
- 0
- Views
- 4.5k
-
-
-
-
Convert Formula References
- Dave Hawley
June 25, 2005 at 12:18 AM
- Dave Hawley
June 25, 2005 at 12:18 AM
-
- Replies
- 0
- Views
- 4.6k
-
-
-
-
Alternate Row Coloring
- Dave Hawley
June 24, 2005 at 9:44 AM
- Dave Hawley
June 24, 2005 at 9:44 AM
-
- Replies
- 0
- Views
- 4.5k
-
-
-
-
Stop/Prevent Duplicates
- Dave Hawley
June 24, 2005 at 4:37 AM
- Dave Hawley
June 24, 2005 at 4:37 AM
-
- Replies
- 0
- Views
- 4.4k
-
-
-
-
Create Custom Menu Items with VBA
- Dave Hawley
June 23, 2005 at 8:34 AM
- Dave Hawley
June 23, 2005 at 8:34 AM
-
- Replies
- 0
- Views
- 8.4k
-
-
-
-
Hide & Restore Toolbars in Excel VBA
- Dave Hawley
June 23, 2005 at 3:47 AM
- Dave Hawley
June 23, 2005 at 3:47 AM
-
- Replies
- 0
- Views
- 11k
-
-
-
-
Data Validation
- Dave Hawley
June 22, 2005 at 8:57 AM
- Dave Hawley
June 22, 2005 at 8:57 AM
-
- Replies
- 0
- Views
- 4.5k
-
-
-
-
Creating a Worksheet Index Sheet
- Dave Hawley
June 21, 2005 at 11:19 AM
- Dave Hawley
June 21, 2005 at 11:19 AM
-
- Replies
- 0
- Views
- 7.5k
-
-
-
-
Lookup Left in Table
- Dave Hawley
June 20, 2005 at 7:54 AM
- Dave Hawley
June 20, 2005 at 7:54 AM
-
- Replies
- 0
- Views
- 6.4k
-
-
-
-
Highlight Duplicates
- Dave Hawley
June 15, 2005 at 8:38 AM
- Dave Hawley
June 15, 2005 at 8:38 AM
-
- Replies
- 0
- Views
- 10k
-