View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SuperJas SuperJas is offline
external usenet poster
 
Posts: 66
Default Transposing numbers

Straight from the Macro Recorder:

Sub Transpose()

Range("G1:M1").Select
Selection.Copy
Range("G9").Select
Selection.PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=False _
, Transpose:=True
End Sub

SuperJas.