Thread: Copy cell macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
abzpowr abzpowr is offline
external usenet poster
 
Posts: 1
Default 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