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
Mahendra Kumar03/23/17101010Best Expert.
Michelle09/08/16101010Hi Jan, this works perfect. I am .....

Recent Answers from Jan Karel Pieterse

2017-01-11 Chart appearance.:

The entire routine should read:    Sub SaveCharts()      Dim oSh As Worksheet      Dim oCht As ChartObject      For Each oSh In Worksheets          For Each oCht In oSh.ChartObjects          oCht.Chart

2017-01-10 Chart appearance.:

The macro saves in whatever Excel thinks is the current folder. If you post the macro here I can adjust so that it saves to the same folder as the workbook is in. Basically, you would need to add this

2017-01-07 Chart appearance.:

Another way is to use a small macro:    Sub SaveCharts()      Dim oSh As Worksheet      Dim oCht As ChartObject      For Each oSh In Worksheets          For Each oCht In oSh.ChartObjects          oCht

2017-01-06 Chart appearance.:

Have you seen this article, perhaps it helps you?

2016-11-05 Number of different names:

Hi Richard,    There are different ways to do that.    1. A pivot table    Simply create a blank pivot table using insert, pivot table and click on the name field to add it to the row area.      2. An


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


©2017 All rights reserved.