Macro for 'Paste Special'

  • Thread starter Thread starter Jeremy Leonard
  • Start date Start date
J

Jeremy Leonard

Is there a way to set a macro up so that perform a 'paste special'
into whatever cell is currently highlited?

Thanks in advance.
 
Is there a way to set a macro up so that perform a 'paste special'
into whatever cell is currently highlited?

Thanks in advance.
Click to expand...

Never mind. I figured it out.
 
Hi,

Why bother with a macro, in most cases you can put a button on the toolbar
to do whatever Paste Special command you want: Value, Formulas, Links,
Transpose, No Borders, or Paste Special itself.
 
I set it up as a macro because I know how to assign a keyboard
shortcut for a macro.
 
Back
Top