And how do you know what range to copy and what cell to paste?

Delphine wrote:

This is my code:

Range("A1:K482").Select
Selection.Copy
Range("M1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=True

Thank you,
Delphine

--

Dave Peterson