Why not use the object model parts provided for this:
With ActiveChart.Axes(xlValue, xlPrimary)
.MinimumScale = 0
.MaximumScale = 100
.MajorUnit = 10
End With
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"MacroPete" wrote in message
...
In a macro I would like to use Ctrl-V to paste minimum and maximum values
into a chart's "Format Axis".
But "Record Macro" translates the keypress Ctrl-V into "Paste".
In manual (non-macro) mode, "Edit/Paste" does not work, but Ctrl-V does.
So,
in the macro, since Ctrl-V is translated into Paste, the macro does not
work.
How do I get the macro routine to recognize the keypress Ctrl-V without
the
macro translating it to Paste.
I have checked out ASCII and ANSI codes with no success.