| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
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 > (E-Mail Removed) > "N+" <(E-Mail Removed)> wrote in message > news:874740E1-6109-44E2-8E8C-(E-Mail Removed)... > > hi all i need to make a cut - insert(value) without using select command > > of > > macros.. > > can u help me ?!? ty ! > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| SELECT INSERT | DS | Microsoft Access Form Coding | 1 | 24th Apr 2008 02:18 AM |
| insert into ... select ... from ...where...in | nicholas | Microsoft ASP .NET | 6 | 17th Nov 2004 08:57 PM |
| INSERT INTO..SELECT | David Weilmuenster | Microsoft Excel Programming | 3 | 2nd Aug 2004 08:05 AM |
| Why INSERT, then SELECT | Andy Sze | Microsoft ASP .NET | 3 | 11th Mar 2004 03:58 AM |
| select then insert | =?Utf-8?B?bWFyaw==?= | Microsoft ADO .NET | 1 | 23rd Jan 2004 05:03 PM |
