You are here:

Excel/Expert Profile

Ask A Question

Jan Karel Pieterse


Follow me on:


Excel and Excel/VBA questions

Experience in the area

Excel MVP


Self employed Excel developer


Bachelor in Chemical Engineering

Awards and Honors

Microsoft MVP award since 2002

Past/Present Clients

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

This expert accepts donations:      

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
Michelle09/08/16101010Hi Jan, this works perfect. I am .....
Prashant S Akerkar 08/29/16101010Dear Jan Thanks. Prashant
Prashant S Akerkar 08/29/16101010Dear Jan Thanks. Prashant
Prashant S Akerkar 08/19/16101010Dear Jan Thanks. Prashant
Mustafa08/17/16101010Thank you... so near and yet so .....

Recent Answers from Jan Karel Pieterse

2016-09-06 Text to date:

Hi Michelle,    This problem is due to the fact that VBA speaks American and tries to convert dates to the US MDY format, regardless of your text-to-columns settings. Instead, try this little macro:  

2016-09-05 Text to date:

Can you please share your macro code?

2016-08-29 Plotting Histograms in Excel software.:

You mean the color of the chart elements? Of course you can. But how to do it depends a bit on your version of Excel. This is a basic editing operation in Excel which any beginner textbook should explain

2016-08-29 Plotting Histograms in Excel software.:

Hi Prashant,    Depends on your version of Excel. As of Excel 2010 exporting to PDF is a built-in feature. IN Excel 2010 it is File, Save & Send, Create PDF/XPS Document.

2016-04-07 Amended: VBA events problem: slicer and unlinked PivotTable:

Key is that "SOurce" is not about the Data itself, but rather about using the same Pivot Cache. If you create two pivottables, each having their own pivot cache then you cannot join them with the same


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


All Answers

Answers by Expert:

Ask Experts


©2016 All rights reserved.