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 |
|---|---|---|---|---|---|---|
| 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 |
| Dave | 12/21/08 | 10 | 10 | 10 | 10 | Thank you! |
| Chetan | 12/18/08 | 10 | 10 | 10 | 10 | Thanks a lot....! |
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
Glyn, Sorry I clicked the wrong button. To do this you need to use an array function. Chip Pearson has a great tutorial on array functions on his site http://www.cpearson.com/excel/ArrayFormulas.aspx
Sirajuddin, Good news. This will be a much easier project than you anticipate. It can be done with conditional formatting instead of a macro. First, do you want to only color the cell if the duplicate
Answers by Expert:

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