Excel FAQ
A collection of the most frequently asked questions in the Excel/VBA forum. Check in Here Before Posting
-
-
-
Prevent Blank/Missing Entries
- Dave Hawley
October 11, 2005 at 3:47 AM
- Dave Hawley
October 11, 2005 at 3:47 AM
-
- Replies
- 0
- Views
- 3.7k
-
-
-
-
Password Protect Worksheet Viewing
- Dave Hawley
October 10, 2005 at 11:05 AM
- Dave Hawley
October 10, 2005 at 11:05 AM
-
- Replies
- 0
- Views
- 6.2k
-
-
-
-
Run Macro on Data Enter/Entry
- Dave Hawley
October 7, 2005 at 3:22 AM
- Dave Hawley
October 7, 2005 at 3:22 AM
-
- Replies
- 0
- Views
- 39k
-
-
-
-
Automatically Run Macros Upon Opening
- Dave Hawley
October 6, 2005 at 5:53 AM
- Dave Hawley
October 6, 2005 at 5:53 AM
-
- Replies
- 0
- Views
- 6k
-
-
-
-
Send Email
- Dave Hawley
October 5, 2005 at 3:40 AM
- Dave Hawley
October 5, 2005 at 3:40 AM
-
- Replies
- 0
- Views
- 4.6k
-
-
-
-
Stop Case Sensitivity in VBA Code
- Dave Hawley
October 4, 2005 at 7:34 AM
- Dave Hawley
October 4, 2005 at 7:34 AM
-
- Replies
- 0
- Views
- 4.1k
-
-
-
-
Return Weekday, or Day of Week
- Dave Hawley
October 3, 2005 at 9:07 AM
- Dave Hawley
October 3, 2005 at 9:07 AM
-
- Replies
- 0
- Views
- 22k
-
-
-
-
Return Week Number
- Dave Hawley
October 3, 2005 at 8:26 AM
- Dave Hawley
October 3, 2005 at 8:26 AM
-
- Replies
- 0
- Views
- 8.7k
-
-
-
-
Add/Subtract n Months from a Date
- Dave Hawley
September 30, 2005 at 8:37 AM
- Dave Hawley
September 30, 2005 at 8:37 AM
-
- Replies
- 0
- Views
- 10k
-
-
-
-
Return Last Day of Month
- Dave Hawley
September 30, 2005 at 8:36 AM
- Dave Hawley
September 30, 2005 at 8:36 AM
-
- Replies
- 0
- Views
- 9.4k
-
-
-
-
Conditional Formatting 3 Criteria Limit
- Dave Hawley
September 29, 2005 at 10:06 AM
- Dave Hawley
September 29, 2005 at 10:06 AM
-
- Replies
- 0
- Views
- 6.6k
-
-
-
-
Calculate a Persons Age
- Dave Hawley
September 29, 2005 at 6:22 AM
- Dave Hawley
September 29, 2005 at 6:22 AM
-
- Replies
- 0
- Views
- 7.2k
-
-
-
-
Automatically Force Text to Upper/Proper Case
- Dave Hawley
September 21, 2005 at 8:36 AM
- Dave Hawley
September 21, 2005 at 8:36 AM
-
- Replies
- 0
- Views
- 7.9k
-
-
-
-
Change Text to Upper Case or Proper Case
- Raina
September 20, 2005 at 4:31 AM
- Raina
September 20, 2005 at 4:31 AM
-
- Replies
- 0
- Views
- 12k
-
-
-
-
Delete Named Ranges Enmass
- Raina
September 19, 2005 at 8:59 AM
- Raina
September 19, 2005 at 8:59 AM
-
- Replies
- 0
- Views
- 5.5k
-
-
-
-
Add Command Button to Right Click Menu
- Dave Hawley
September 16, 2005 at 8:38 AM
- Dave Hawley
September 16, 2005 at 8:38 AM
-
- Replies
- 0
- Views
- 11k
-
-
-
-
Group Worksheets by Name Tab Color
- Dave Hawley
September 15, 2005 at 7:57 AM
- Dave Hawley
September 15, 2005 at 7:57 AM
-
- Replies
- 0
- Views
- 7.1k
-
-
-
-
Sort Arrays. Sorting Arrays
- Dave Hawley
September 14, 2005 at 7:58 AM
- Dave Hawley
September 14, 2005 at 7:58 AM
-
- Replies
- 0
- Views
- 8.6k
-
-
-
-
Sort/Sorting Sheets/Worksheets
- Dave Hawley
September 13, 2005 at 10:20 AM
- Dave Hawley
September 13, 2005 at 10:20 AM
-
- Replies
- 0
- Views
- 4.7k
-
-
-
-
Find Method in VBA
- Dave Hawley
September 13, 2005 at 8:20 AM
- Dave Hawley
September 13, 2005 at 8:20 AM
-
- Replies
- 0
- Views
- 7.8k
-