ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Paste special transpose macro (https://www.excelbanter.com/excel-programming/406386-paste-special-transpose-macro.html)

hhwar

Paste special transpose macro
 
I am trying to write a macro that will paste special transpose in the cell I
am currently in. I am having no luck. Please help!

JLGWhiz

Paste special transpose macro
 
You need to provide more detail than that. What are you copying. Transpose
converts from vertical to horizontal and vice versa. I don't know if you can
transpose one cell.

"hhwar" wrote:

I am trying to write a macro that will paste special transpose in the cell I
am currently in. I am having no luck. Please help!


hhwar

Paste special transpose macro
 
I am copying a number of cells from a row and I need a macro that after I
copy them and click in the cell that I want to paste them into the macro will
paste special values transpose.

Thanks

"JLGWhiz" wrote:

You need to provide more detail than that. What are you copying. Transpose
converts from vertical to horizontal and vice versa. I don't know if you can
transpose one cell.

"hhwar" wrote:

I am trying to write a macro that will paste special transpose in the cell I
am currently in. I am having no luck. Please help!



All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com