Thread: Column into Row in EXCEl
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kalpesh[_2_] Kalpesh[_2_] is offline
external usenet poster
  
Posts: 15
Default Column into Row in EXCEl
Hi,

Assuming your list starts from a1, following should work

Range("a1:h1") = WorksheetFunction.Transpose(Range("a1:a8"))

HTH
Kalpesh

Reply With QuoteReply With Quote