Hi
record a macro while doing this ('Tools - Macro - Record macro') and
assign this macro to a shortcut/button

--
Regards
Frank Kabel
Frankfurt, Germany

"Rey A." schrieb im Newsbeitrag
...
To all gurus:

I have a repetitive task wherein I execute "Paste Special",
"Transpose", "OK" respectively after copying cells. Can someone show
me how I can create a button for this sequence of keystrokes.

Appreciate any help.