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

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.