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 you
needs.
"ceconik" wrote:
Hi all
I wold like to ask about microsoft exel macros , how i can mak
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 ,Evrethink is ok for this example , but i would like to compar
two cell and
if value from cell is same copy and paste only this , no evrethink
Thenks agai
--
ceconi
-----------------------------------------------------------------------
ceconik's Profile:
http://www.excelforum.com/member.php...fo&userid=2806
View this thread:
http://www.excelforum.com/showthread.php?threadid=47580