JNW Wrote:
Try

Sub CopyValues()
With Sheets("My Sheet")
.Range("A2:A6").Copy
.Range("B2").Pastespecial
End With
Application.CutCopyMode = False
End sub

You'll need to rename the sheet and redefine the ranges to suit your
needs.
"ceconik" wrote:


Hi all
I wold like to ask about microsoft exel macros , how i can make
maiby
macros for this :
i have two columns whit same value example
1 A1 B1
2 12 48
3 74 12
4 14 74
5 48 14
6 5 65
how a can move value in same cell ,make this
1 A1 B1
2 12 12
3 74 74
4 14 14
5 48 48
6 5 65

Thenks


--
ceconik

------------------------------------------------------------------------
ceconik's Profile:
http://www.excelforum.com/member.php...o&userid=28066
View this thread:
http://www.excelforum.com/showthread...hreadid=475801






Thenks, Themks , Thenks


--
ceconik
------------------------------------------------------------------------
ceconik's Profile: http://www.excelforum.com/member.php...o&userid=28066
View this thread: http://www.excelforum.com/showthread...hreadid=475801