Thanks very much.

I don't think I have a Personal.xls file. Do I need to set one up, or can
it run from within a workbook template instead?

Liz


"Bernie Deitrick" wrote:

Liz,

Copy the macro below into your Personal.xls, then add a custom toolbar button and assign it the
macro.

When you want to transpose a range, copy it, select the destination anchor cell, and press your
custom button.

HTH,
Bernie
MS Excel MVP

Sub PasteTranspose()
If Application.CutCopyMode Then _
Selection.PasteSpecial Transpose:=True
End Sub


"Liz" wrote in message
...
Is it possible to create a button on a toolbar for 'Transpose' to save me
going through 'paste special' each time.