Thread: visual basic command to special paste a row of formulas into value
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 visual basic command to special paste a row of formulas into value
I am currently using this macro to copy a row of values from one sheet to
another using vsual basic editor

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

CopyRangeAdd enumRange, strFrom & "J16:U21", strTo & "J16:U21"

Currently this macro is copying values in one sheet to a value in another
sheet

I would now like to copy formulas in one sheet to values in another sheet



Reply With QuoteReply With Quote