View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Excel2000...use Ctrl-V, not Paste, in macro to Format Axis in a ch

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.