Thread: Transpose Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
weeper weeper is offline
external usenet poster
 
Posts: 7
Default Transpose Range

How can I enumerate and transpose all cells in a range (array).

here is my range (before) ("A1:B4"):

A B
-- --
1 2
3 4
5 6
7 8

what i want do to is transpose to Column C like this

C
--
1
2
3
4
5
6
7
8

Thanks
w