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

converting formulas into values using a macro in visual basic edit
 

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" wrote in message ...
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