Jan Karel Pieterse - Excel - Business Software - Computing/Technology

About > AllExperts
	Search for

Main Menu

Login (Experts Only)

About Us · FAQ · Tell Friends About Us · Link To Us · Free Encyclopedia · Disclaimer · Tech Support

You are here: AllExperts > Computing/Technology > Business Software > Excel

Expert Profile: Jan Karel Pieterse

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

	View Past Answers	View Detailed Ratings

Average Ratings
Prestige Points: 5670
Knowledge	9.86 Best of the best
Clarity of Response	9.72 Best of the best
Timeliness	9.90 Best of the best
Politeness	9.94 Best of the best
Number Of Questions (in Past 24 Hours)		3
Max Questions to be Asked (in 24 Hour period)		3
Total Questions (since joining AllExperts)		664

Recent Reviews from Users

Knowl	Clarity	Time	Politeness	Date
10	10	10	10	12/03/08
10	10	10	10	12/03/08
10	10	10	10	12/03/08
10	10	10	10	12/01/08
10	9	10	10	11/28/08

User Comments

Oh my goodness! Works like a charm!! Thank you - you have helped me immensely to potentially impress my employers and show them that I'm needed here!
(Laura on 12/03/08)

Thanks
(Max on 12/03/08)

Very Helpful
(Mason on 12/03/08)

thanks thats exactly what i wanted.
(Dani on 12/01/08)

Thank you Jan. I appreciate your help. It took me a couple of tries to get it to work but eventually it did. You saved me an enormous amount of time!
(Ryan on 11/28/08)

View All Comments

	View Past Answers	View Detailed Ratings

Recent Answers from Jan Karel Pieterse

2008-12-02 Check Code: An End With was missing at the end: Option Explicit Sub Mail_Range() 'Working in 2000-2007 Dim Source As Range Dim Dest As Workbook Dim wb As Workbook Dim TempFilePath As String...

2008-12-02 Find cell then use its corrdinates: You need to skip the entire section that uses rFound, not just the goto statement. Modify your code like this: On Error Resume Next With sh Set rFound = .Columns(1).Find(What:="cat"...

2008-11-27 text box: Something like this: - Make sure row 1 is empty - rightclick the sheet's tab and choose View Code - paste this code: Option Explicit Dim bDisableEvent As Boolean Private Sub Worksheet_Change(ByVal...

2008-11-27 Formulae: No it just means we'll have to use VBA. Right-click the worksheet tab in question and select View code. Paste this code in the code window: Option Explicit Private Sub Worksheet_Change(ByVal...

2008-11-27 Formulae: Is the formula you wrote directly adjacent to the data you enter? Are you skipping rows between consecutive entries by any chance? In other words, are the rows with same data directly below each other...