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

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