copying values only from another workbook

[mwc0914]

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?

[Gary''s Student]

Try doing the copy and paste in two separate statements

GBVTWkbk.Worksheets("Money Winners ").Range("b6:b201").Copy
NewWkbk.Worksheets("temp").Range("d1:d196").PasteSpecial 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
>
>