You are here:

Excel/Expert Profile

Chad Welch

U.S.

Maxed Out

Expertise

I have a lot of experience with VBA; Sub procedures, functions etc. I am also very familiar with array formulas.

Experience in the area

I've worked with Excel for several years. I've been answering questions on various groups and lists for a while.

Organizations

Brainbench MVP for MS Excel.

Average Ratings

Recent Reviews from Users

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....!

Recent Answers from Chad Welch

2009-11-07 Password protect cell editing:

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

2009-10-11 IF (multiple match tests) THEN:

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

2009-10-04 Equivalent Networkdays:

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

2009-04-19 excell count function:

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

2009-04-06 Cell Value Comparison:

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

Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Encyclopedia

Browse Answers: