Hi,

Can you email me the file, do not attached to this newsgroup.

I haven't seen this when the numbers in cells where modified and as I
said I can not get you code to re create the problem.

Cheers
Andy

Sinus Log wrote:
Andy Pope wrote:

Hi,

I could not reproduce the problem from your description, although I
have seen it in the past.

Why not read the top and left properties of the legend at the
beginning of your macro and set them at the end if they have changed.

Cheers
Andy


How do I do that ? It took me a couple of hours to figure out how to
program the number format. Could you tell me how to modify my code,
please ?
With graphique.Chart.Axes(xlCategory)
.MinimumScale = premPointComp
.MaximumScale = dernPointComp
.TickLabels.NumberFormat = formatNombres
End With

Thanks for your reply

PS: More on the symptoms
There's no problem until the macro is executed. The problem shows
afterwards when I modify a cell, even if that doesn't trigger the macro.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info