Cut - Insert without .Select
 

hi all i need to make a cut - insert(value) without using select command of
macros..
can u help me ?!? ty !

Cut - Insert without .Select
 

Sub movedata()
Range("c7").Cut Range("f7").insert
End Sub
or maybe this is what you want
Sub movedata()
Range("c6").Copy Range("f7")
Range("c6").ClearContents
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"N+" wrote in message
...
hi all i need to make a cut - insert(value) without using select command
of
macros..
can u help me ?!? ty !

Cut - Insert without .Select
 

built easiest ;)

Range("A80").Value = Range("F2").Value

Range("A80").Copy
Range("A81").Insert Shift:=xlDown

with this i can move thru the sheet as usual when the macro is running..


"Don Guillett" wrote:

Sub movedata()
Range("c7").Cut Range("f7").insert
End Sub
or maybe this is what you want
Sub movedata()
Range("c6").Copy Range("f7")
Range("c6").ClearContents
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"N+" wrote in message
...
hi all i need to make a cut - insert(value) without using select command
of
macros..
can u help me ?!? ty !