Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying values only from another workbook
I have the following statement: GBVTWkbk.Worksheets("Money Winners ").Range("b6:b201").Copy _ Destination:=NewWkbk.Worksheets("temp").Range("d1: d196").PasteSpecial I need the PasteSpecial part because the data in cells from the origin workbook are have formulas behind them, and I want to copy over their values only. When I try to add Paste:=xlValues, Operation:=xlNone, SkipBlanks:= False, Transpose:=False after the PasteSpecial I am getting a compile error. How can I copy over just values in cells that have formulas in them? -- mwc0914 ------------------------------------------------------------------------ mwc0914's Profile: http://www.excelforum.com/member.php...o&userid=24130 View this thread: http://www.excelforum.com/showthread...hreadid=520161 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying values only from another workbook
Try doing the copy and paste in two separate statements
GBVTWkbk.Worksheets("Money Winners ").Range("b6:b201").Copy NewWkbk.Worksheets("temp").Range("d1:d196").PasteS pecial Paste:=xlPasteValues -- Gary's Student "mwc0914" wrote: I have the following statement: GBVTWkbk.Worksheets("Money Winners ").Range("b6:b201").Copy _ Destination:=NewWkbk.Worksheets("temp").Range("d1: d196").PasteSpecial I need the PasteSpecial part because the data in cells from the origin workbook are have formulas behind them, and I want to copy over their values only. When I try to add Paste:=xlValues, Operation:=xlNone, SkipBlanks:= False, Transpose:=False after the PasteSpecial I am getting a compile error. How can I copy over just values in cells that have formulas in them? -- mwc0914 ------------------------------------------------------------------------ mwc0914's Profile: http://www.excelforum.com/member.php...o&userid=24130 View this thread: http://www.excelforum.com/showthread...hreadid=520161 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying workbook formating to a differnent workbook | Excel Worksheet Functions | |||
formula for copying values from one workbook to another | Excel Worksheet Functions | |||
Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
Copying values from one Workbook to Another | Excel Programming | |||
copying values form one workbook to other | Excel Programming |