Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 14th, 2007, 12:05 AM
Authorized User
 
Join Date: Apr 2007
Location: Silvassa, Dadra & Nagar Haveli, India.
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default Transpose the data

I want to use the transpose command for a range of horizontal cells. The data in these cells are of mixed type i.e some cells contains the numbers, some are having text in it.

Also suggest if i can use a command instead of using mouse for doing paste special function, and then transpose.

Yogesh

Yogesh
__________________
Yogesh
 
Old September 14th, 2007, 01:37 AM
Friend of Wrox
Points: 3,060, Level: 23
Points: 3,060, Level: 23 Points: 3,060, Level: 23 Points: 3,060, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2005
Location: , , .
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Hi Yogesh

Try if the following link helps

http://vbadud.blogspot.com/2007/03/t...cel-range.html

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)
 
Old September 15th, 2007, 11:09 AM
Authorized User
 
Join Date: Jul 2007
Location: , , .
Posts: 13
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
quote:Originally posted by Shasur
 Hi Yogesh

Try if the following link helps

http://vbadud.blogspot.com/2007/03/t...cel-range.html

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)
Very helpful,thanks a lot


-------------------------------------------------------------------------------------

http://alwaysdirectory.com
http://coco4info.com




Similar Threads
Thread Thread Starter Forum Replies Last Post
Transpose Tables abc052107 Visual Studio 2005 0 August 23rd, 2007 12:40 AM
How to Transpose this type data jaincafe Access 1 November 27th, 2006 05:58 AM
Help with transpose fegasa Excel VBA 3 April 7th, 2006 03:43 AM
Transpose Rows JpJoe Access 10 March 17th, 2005 08:15 AM
transfer and transpose sham Excel VBA 4 March 6th, 2005 12:13 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.