converting formulas into values using a macro in visual basic edit

Currently I am using the following macro command to copy cells from one
worksheet to another in visual basic editor


strFrom = "[Data Source - Golf]Source Prior Year Statistics!"
strTo = "[Data Source - Golf]Source Prior Year +1 Statistics!"

CopyRangeAdd enumRange, strFrom & "J14:U14", strTo & "J14:U14"

I am now attempting to copy formulas located in cells J14 to U14 into
another worksheet, so that in the second worksheet they are values.

Can anyone advise what needs to be cahnged in the above macro line

Hi F.C

You can use Value

Sheets("Sheet2").Range("A1:A10").Value = Sheets("Sheet1").Range("A1:A10").Value


--
Regards Ron de Bruin
http://www.rondebruin.nl


"F.C" <[email protected]> wrote in message news:[email protected]...
> Currently I am using the following macro command to copy cells from one
> worksheet to another in visual basic editor
>
>
> strFrom = "[Data Source - Golf]Source Prior Year Statistics!"
> strTo = "[Data Source - Golf]Source Prior Year +1 Statistics!"
>
> CopyRangeAdd enumRange, strFrom & "J14:U14", strTo & "J14:U14"
>
> I am now attempting to copy formulas located in cells J14 to U14 into
> another worksheet, so that in the second worksheet they are values.
>
> Can anyone advise what needs to be cahnged in the above macro line