software

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

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 Subquot;Lizquot; gt; wrote in message
news
gt; Is it possible to create a button on a toolbar for 'Transpose' to save me
gt; going through 'paste special' each time.
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?

Lizquot;Bernie Deitrickquot; wrote:

gt; Liz,
gt;
gt; Copy the macro below into your Personal.xls, then add a custom toolbar button and assign it the
gt; macro.
gt;
gt; When you want to transpose a range, copy it, select the destination anchor cell, and press your
gt; custom button.
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt; Sub PasteTranspose()
gt; If Application.CutCopyMode Then _
gt; Selection.PasteSpecial Transpose:=True
gt; End Sub
gt;
gt;
gt; quot;Lizquot; gt; wrote in message
gt; news
gt; gt; Is it possible to create a button on a toolbar for 'Transpose' to save me
gt; gt; going through 'paste special' each time.
gt;
gt;
gt;

Liz,

It would be much better from within Personal.xls, since it would be available at any time and be
available within any workbook.

You should set one up. Simply start the macro recorder, and select the option to store the macro in
quot;Personal macro workbookquot; Excel will take care of creating it for you. Then store the previous code
in that workbook, through the VB Editor.

HTH,
Bernie
MS Excel MVPquot;Lizquot; gt; wrote in message
...
gt; Thanks very much.
gt;
gt; I don't think I have a Personal.xls file. Do I need to set one up, or can
gt; it run from within a workbook template instead?
gt;
gt; Liz
gt;
gt;
gt; quot;Bernie Deitrickquot; wrote:
gt;
gt;gt; Liz,
gt;gt;
gt;gt; Copy the macro below into your Personal.xls, then add a custom toolbar button and assign it the
gt;gt; macro.
gt;gt;
gt;gt; When you want to transpose a range, copy it, select the destination anchor cell, and press your
gt;gt; custom button.
gt;gt;
gt;gt; HTH,
gt;gt; Bernie
gt;gt; MS Excel MVP
gt;gt;
gt;gt; Sub PasteTranspose()
gt;gt; If Application.CutCopyMode Then _
gt;gt; Selection.PasteSpecial Transpose:=True
gt;gt; End Sub
gt;gt;
gt;gt;
gt;gt; quot;Lizquot; gt; wrote in message
gt;gt; news
gt;gt; gt; Is it possible to create a button on a toolbar for 'Transpose' to save me
gt;gt; gt; going through 'paste special' each time.
gt;gt;
gt;gt;
gt;gt;
Thanks very much for your reply. I'll try it out. I've always been a bit
wary of macros and avoided them, but maybe I have to start using them!
Liz

quot;Bernie Deitrickquot; wrote:

gt; Liz,
gt;
gt; It would be much better from within Personal.xls, since it would be available at any time and be
gt; available within any workbook.
gt;
gt; You should set one up. Simply start the macro recorder, and select the option to store the macro in
gt; quot;Personal macro workbookquot; Excel will take care of creating it for you. Then store the previous code
gt; in that workbook, through the VB Editor.
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;Lizquot; gt; wrote in message
gt; ...
gt; gt; Thanks very much.
gt; gt;
gt; gt; I don't think I have a Personal.xls file. Do I need to set one up, or can
gt; gt; it run from within a workbook template instead?
gt; gt;
gt; gt; Liz
gt; gt;
gt; gt;
gt; gt; quot;Bernie Deitrickquot; wrote:
gt; gt;
gt; gt;gt; Liz,
gt; gt;gt;
gt; gt;gt; Copy the macro below into your Personal.xls, then add a custom toolbar button and assign it the
gt; gt;gt; macro.
gt; gt;gt;
gt; gt;gt; When you want to transpose a range, copy it, select the destination anchor cell, and press your
gt; gt;gt; custom button.
gt; gt;gt;
gt; gt;gt; HTH,
gt; gt;gt; Bernie
gt; gt;gt; MS Excel MVP
gt; gt;gt;
gt; gt;gt; Sub PasteTranspose()
gt; gt;gt; If Application.CutCopyMode Then _
gt; gt;gt; Selection.PasteSpecial Transpose:=True
gt; gt;gt; End Sub
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Lizquot; gt; wrote in message
gt; gt;gt; news
gt; gt;gt; gt; Is it possible to create a button on a toolbar for 'Transpose' to save me
gt; gt;gt; gt; going through 'paste special' each time.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

gt; I've always been a bit
gt; wary of macros and avoided them, but maybe I have to start
gt; using them!

There's no reason to be wary of macros, and no reason to avoid
them. Once you become even a bit proficient with VBA, you'll find
that a whole new world of Excel opens up.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

quot;Lizquot; gt; wrote in message
...
gt; Thanks very much for your reply. I'll try it out. I've always
gt; been a bit
gt; wary of macros and avoided them, but maybe I have to start
gt; using them!
gt; Liz
gt;
gt; quot;Bernie Deitrickquot; wrote:
gt;
gt;gt; Liz,
gt;gt;
gt;gt; It would be much better from within Personal.xls, since it
gt;gt; would be available at any time and be
gt;gt; available within any workbook.
gt;gt;
gt;gt; You should set one up. Simply start the macro recorder, and
gt;gt; select the option to store the macro in
gt;gt; quot;Personal macro workbookquot; Excel will take care of creating it
gt;gt; for you. Then store the previous code
gt;gt; in that workbook, through the VB Editor.
gt;gt;
gt;gt; HTH,
gt;gt; Bernie
gt;gt; MS Excel MVP
gt;gt;
gt;gt;
gt;gt; quot;Lizquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Thanks very much.
gt;gt; gt;
gt;gt; gt; I don't think I have a Personal.xls file. Do I need to set
gt;gt; gt; one up, or can
gt;gt; gt; it run from within a workbook template instead?
gt;gt; gt;
gt;gt; gt; Liz
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Bernie Deitrickquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Liz,
gt;gt; gt;gt;
gt;gt; gt;gt; Copy the macro below into your Personal.xls, then add a
gt;gt; gt;gt; custom toolbar button and assign it the
gt;gt; gt;gt; macro.
gt;gt; gt;gt;
gt;gt; gt;gt; When you want to transpose a range, copy it, select the
gt;gt; gt;gt; destination anchor cell, and press your
gt;gt; gt;gt; custom button.
gt;gt; gt;gt;
gt;gt; gt;gt; HTH,
gt;gt; gt;gt; Bernie
gt;gt; gt;gt; MS Excel MVP
gt;gt; gt;gt;
gt;gt; gt;gt; Sub PasteTranspose()
gt;gt; gt;gt; If Application.CutCopyMode Then _
gt;gt; gt;gt; Selection.PasteSpecial Transpose:=True
gt;gt; gt;gt; End Sub
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Lizquot; gt; wrote in message
gt;gt; gt;gt; news
gt;gt; gt;gt; gt; Is it possible to create a button on a toolbar for
gt;gt; gt;gt; gt; 'Transpose' to save me
gt;gt; gt;gt; gt; going through 'paste special' each time.
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
Many thanks for your help with the macro for Transpose. I've managed to get
it into my personal.xls and it works wonderfully!
Liz

quot;Chip Pearsonquot; wrote:

gt; gt; I've always been a bit
gt; gt; wary of macros and avoided them, but maybe I have to start
gt; gt; using them!
gt;
gt; There's no reason to be wary of macros, and no reason to avoid
gt; them. Once you become even a bit proficient with VBA, you'll find
gt; that a whole new world of Excel opens up.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt;
gt;
gt; quot;Lizquot; gt; wrote in message
gt; ...
gt; gt; Thanks very much for your reply. I'll try it out. I've always
gt; gt; been a bit
gt; gt; wary of macros and avoided them, but maybe I have to start
gt; gt; using them!
gt; gt; Liz
gt; gt;
gt; gt; quot;Bernie Deitrickquot; wrote:
gt; gt;
gt; gt;gt; Liz,
gt; gt;gt;
gt; gt;gt; It would be much better from within Personal.xls, since it
gt; gt;gt; would be available at any time and be
gt; gt;gt; available within any workbook.
gt; gt;gt;
gt; gt;gt; You should set one up. Simply start the macro recorder, and
gt; gt;gt; select the option to store the macro in
gt; gt;gt; quot;Personal macro workbookquot; Excel will take care of creating it
gt; gt;gt; for you. Then store the previous code
gt; gt;gt; in that workbook, through the VB Editor.
gt; gt;gt;
gt; gt;gt; HTH,
gt; gt;gt; Bernie
gt; gt;gt; MS Excel MVP
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Lizquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Thanks very much.
gt; gt;gt; gt;
gt; gt;gt; gt; I don't think I have a Personal.xls file. Do I need to set
gt; gt;gt; gt; one up, or can
gt; gt;gt; gt; it run from within a workbook template instead?
gt; gt;gt; gt;
gt; gt;gt; gt; Liz
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Bernie Deitrickquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; Liz,
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Copy the macro below into your Personal.xls, then add a
gt; gt;gt; gt;gt; custom toolbar button and assign it the
gt; gt;gt; gt;gt; macro.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; When you want to transpose a range, copy it, select the
gt; gt;gt; gt;gt; destination anchor cell, and press your
gt; gt;gt; gt;gt; custom button.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; HTH,
gt; gt;gt; gt;gt; Bernie
gt; gt;gt; gt;gt; MS Excel MVP
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Sub PasteTranspose()
gt; gt;gt; gt;gt; If Application.CutCopyMode Then _
gt; gt;gt; gt;gt; Selection.PasteSpecial Transpose:=True
gt; gt;gt; gt;gt; End Sub
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;Lizquot; gt; wrote in message
gt; gt;gt; gt;gt; news
gt; gt;gt; gt;gt; gt; Is it possible to create a button on a toolbar for
gt; gt;gt; gt;gt; gt; 'Transpose' to save me
gt; gt;gt; gt;gt; gt; going through 'paste special' each time.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;