Copy cell macro
 

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

Copy cell macro
 

Will it work by doing 2 copy & pastes?

Range("C12:C12").Select
Selection.Copy
Sheets("Liste").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:=True, Transpose:=False

Range("D12:D22").Select
Selection.Copy
Sheets("Liste").Select
Range("C1").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:=True, Transpose:=False

Copy cell macro
 

i doesnt work

how can i say that C14-C22 to A14-A22

D14-D22 to C14-22

B14-B22 have to be empty


--
abzpowr
------------------------------------------------------------------------
abzpowr's Profile: http://www.excelforum.com/member.php...o&userid=24941
View this thread: http://www.excelforum.com/showthread...hreadid=384767

Copy cell macro
 

i need really help

we have to select c12:c22 and d12:d22

and we will copy them to A column and C column


--
abzpowr
------------------------------------------------------------------------
abzpowr's Profile: http://www.excelforum.com/member.php...o&userid=24941
View this thread: http://www.excelforum.com/showthread...hreadid=384767

Copy cell macro
 

Not sure I understand your problem but is this a possible solution:

Sub Ekle1()

Range("C12:C12").Copy
Range("Liste!A1").PasteSpecial Paste:=xlValues
Range("D12:D22").Copy
Range("Liste!C1").PasteSpecial Paste:=xlValues
Application.CutCopyMode = False
End Sub

"abzpowr" wrote in
message ...

i need really help

we have to select c12:c22 and d12:d22

and we will copy them to A column and C column


--
abzpowr
------------------------------------------------------------------------
abzpowr's Profile:
http://www.excelforum.com/member.php...o&userid=24941
View this thread: http://www.excelforum.com/showthread...hreadid=384767