Sub Ekle1()
Range("C12:D22").Select
Selection.Copy
Sheets("Liste").Select
Range("A1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:=True, Transpose:=False
End Sub
i have to copy C12:C12 to A1 offset and D12:D22 to C1 offset
B1 have to be blank. So how can i change this macro for me?
(im so sorry, my english is not good)
--
abzpowr
------------------------------------------------------------------------
abzpowr's Profile:
http://www.excelforum.com/member.php...o&userid=24941
View this thread:
http://www.excelforum.com/showthread...hreadid=384767