| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Move cells
Your answer works great thanks but I need the value copied not the formula.
Is there a way to do that. "Weasel" wrote: I'm trying to move a range of cells to a new file and new range I can't get it to work. eg. doc name: sheet1 range: a2:f2 new file: sheet2 new range: a1:f1 Any help would be appreciated |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to Move cells
In that case, use the PasteSpecial method the following way:
Workbooks("book1.xls").Worksheets("sheet1").Range( "a2:f2").Copy Workbooks("book2.xls")Worksheets("sheet2").Range(" a1").PasteSpecial _ xlPasteValues Application.CutCopyMode = False Regards, sebastien "Weasel" wrote: Your answer works great thanks but I need the value copied not the formula. Is there a way to do that. "Weasel" wrote: I'm trying to move a range of cells to a new file and new range I can't get it to work. eg. doc name: sheet1 range: a2:f2 new file: sheet2 new range: a1:f1 Any help would be appreciated |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to Move cells
Thanks alot! Everything works great now thanks.
"sebastienm" wrote: In that case, use the PasteSpecial method the following way: Workbooks("book1.xls").Worksheets("sheet1").Range( "a2:f2").Copy Workbooks("book2.xls")Worksheets("sheet2").Range(" a1").PasteSpecial _ xlPasteValues Application.CutCopyMode = False Regards, sebastien "Weasel" wrote: Your answer works great thanks but I need the value copied not the formula. Is there a way to do that. "Weasel" wrote: I'm trying to move a range of cells to a new file and new range I can't get it to work. eg. doc name: sheet1 range: a2:f2 new file: sheet2 new range: a1:f1 Any help would be appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to move to another cell | New Users to Excel | |||
| Can references (to cells being sorted) move with the cells? | Setting up and Configuration of Excel | |||
| Sorting cells: a list behind the cells do not move with the cell | Excel Discussion (Misc queries) | |||
| Macro to move to specified cells, pause for input at each? | Excel Discussion (Misc queries) | |||
| Macro to Move cells | Excel Programming | |||
Linear Mode
