Thread: converting formulas into values using a macro in visual basic edit
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
F.C[_2_] F.C[_2_] is offline
external usenet poster
  
Posts: 8
Default 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
Reply With QuoteReply With Quote