You are here:

Excel/Expert Profile

Ask A Question

Jan Karel Pieterse

Netherlands

Available

Expertise

Excel and Excel/VBA questions

Experience in the area

Excel MVP

Organizations

Self employed Excel developer

Education/Credentials

Bachelor in Chemical Engineering

Awards and Honors

Microsoft MVP award since 2002

Past/Present Clients

Shell, Fortis bank, ABN-AMRO bank, Morgan Stanley, ...

Average Ratings

Recent Reviews from Users

User	Date	K	C	P	Comments
Susan	02/07/12	9	9	10	Very helpful, quick responses.
Jayendran	02/02/12	10	10	10	Thanks much, it is much useful
Kevin	01/30/12	8	9	10	Thank you very much for the assistance .....
Luis	01/24/12	10	10	10	This is it. Thank you
Mohyi	01/23/12	10	10	10

Recent Answers from Jan Karel Pieterse

2012-02-09 Question about "*.xls":

Hi Ammon, The dir(filespec) command returns the first file in the folder meeting the filespec. Subsequent files are returned by using dir(), e.g.: Dim sFileName as String sFilename=Dir(Cells(2,

2012-01-29 VBA Excel:

Put this code behind the userform: Private Const MCSDEFAULT As String = "Please enter your name" Private Sub TextBox12_Enter() If TextBox12.Value = MCSDEFAULT Then TextBox12.Value =

2012-01-21 Compile Error - Ambiguous Name Detected:

Hi Lisa, First of all, your code can be shortened quite a bit, look at this example that replaaces the firswt two steps of your code: Private Sub Worksheet_Change(ByVal Target As Range) Dim

2012-01-20 Fill diferent columns:

Hi Luis, Some code seems to be missing from what you posted here, correct? Please post the entire routine. For example, you seem to be using a variable called ws, but the code you posted does not show

2012-01-17 if nested:

Hi Samer, You need an entirely different function called VLOOKUP. Put your numbers in two columns next to each other, say cells A1:B11 : 0 0.013 7 0.013 8 0.013 9 0.025 10 0.0675 11 0.3925

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: