Hello All,
Can someone help me with code to:
pasteSpecialValuestranspose

I tried recording, but when I run the macro, I get an
error.

I would ultimayely like to assign ctrl+"a" as my
function. I copied a few cells, then recorded as I
performed the paste......transpose. Here is the
resulting code.

Selection.PasteSpecial Paste:=xlAll, Operation:=xlNone,
SkipBlanks:=False _
, Transpose:=True

Any Ideas Thanks