I want to be able to write this macro so that it will apply to
thousand records along a column. This macro was recorded so that i
transposes 9 cells in a column into 9 cells in a row. There is a blan
cell between the sets of data in the column.
I need help creating the formula below in this macro that "steps" th
copy and paste operation so that it advances down the column in it
copy operation and down the rows in its paste operation. Any ideas?


Sub Macro2()
'
' Macro2 Macro
' Macro recorded 8/26/2005 by Joseph Malki
'

'
Range("A1:A9").Select
Selection.Copy
Range("C1:K1").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone
SkipBlanks:= _
False, Transpose:=True
Range("L3").Select
End Su

--
unknowndevic
-----------------------------------------------------------------------
unknowndevice's Profile: http://www.excelforum.com/member.php...fo&userid=2664
View this thread: http://www.excelforum.com/showthread.php?threadid=39949