Thread: macro - paste special (transpose)
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
paste special, macro, transpose[_2_] paste special, macro, transpose[_2_] is offline
external usenet poster
  
Posts: 2
Default macro - paste special (transpose)
Thx :)

"Gary''s Student" wrote:

Sub Macro1()
Sheets("Sheet1").Select
Rows("1:256").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Sheet2").Select
Rows("1:256").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True
End Sub

--
Gary''s Student - gsnu200826
Reply With QuoteReply With Quote