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 |
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 |
All times are GMT +1. The time now is 07:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com