About > AllExperts  
Search for
  Main Menu Ask a Question Browse Past Answers Meet Top Experts Be an Expert 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
KnowlClarityTimePolitenessDate
1010101012/03/08
1010101012/03/08
1010101012/03/08
1010101012/01/08
10101011/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...
More Answers for "Excel"


Advertise on This Site | User Agreement | Privacy Policy | Kids' Privacy Policy
Copyright  © 2008 All rights reserved. AllExperts is a property of About, Inc.
The About logo, About and About.com are registered trademarks of About, Inc.