Hi All,

Andy helped me once with another related question:
I have a new question:

Situation:
An existing Macro4 program.
I want to make a picture of a chart which is positioned on a chart sheet
(NOT a worksheet).
Scaling is done via the program (set to A5 paper size). and the arguments
are given by the Macro 4 program to a VBA function (works perfect).

This is the working VBA code

Sub ExportGraph(TargetFile As String, Filtr As String)
On Error Resume Next
ActiveChart.Export Filename:=TargetFile, Filtername:=Filtr
End Sub

QUESTION:
I want to get rid of this white border around the graph (4 points or
something)
Can somebody tell me how I have to extend the above code for removal of this
border?

I saw something like this in a previous example but I don't know how I can
get it to work:

With .Chart.Shapes(1)
.Placement = xlMove
.Left = -4
.Top = -4
sngWidth = .Width
sngHeight = .Height
End With

Many thanks in advance.

Eric