You are here:
I have a lot of experience with VBA; Sub procedures, functions etc. I am also very familiar with array formulas.
I've worked with Excel for several years. I've been answering questions on various groups and lists for a while.
Brainbench MVP for MS Excel.
| User | Date | K | C | T | P | Comments |
|---|---|---|---|---|---|---|
| Alex | 11/20/09 | 10 | 10 | 10 | 10 | Thank you! |
| dave | 11/12/09 | 10 | 10 | 10 | 10 | perfect and simple. thanks chad!!! |
| Sancho | 10/05/09 | 10 | 10 | 10 | 10 | Hi Chad, Thank you for the very ..... |
| Andrew | 04/12/09 | 10 | 10 | 10 | 10 | Excellent help. cheers |
| Ann | 04/06/09 | 10 | 10 | 10 | 10 | Thanks for the great help |
Alex, The problem is that Excel doesn't recognize :00:30 as a time. It will however recognize 0:00:30 as 30 seconds. You can "fool" Excel into recognizing the value as a time by using a formula to precede
Hi Dave, If I understand your request correctly, the VLOOKUP function is the one you need. Just paste the following formula into D31/33/35 (adjusting the reference to C31 of course). =VLOOKUP(C31,$D$2:$E$22
Thorsten, That is a functionality that is built into Excel. You don't mention which version of Excel you have and the way to access it is slightly different in Excel 2007 compared to previous versions
Hi Paul, VBA programming is a very literal language, so it is necessary to be this specific. If you need to ensure that every variable is an empty string, then you have to check each one. That said, it
Sanch, A couple of your lines have been commented out. As it stands now, your code will return the same result as NETWORKDAYS. To work properly, uncomment the 2 lines in your For loop: If FindItemInArray(dteHol
Answers by Expert:

©2009 About.com, a part of The New York Times Company. All rights reserved.