Thread: Convert Chart Series Formula to Array Via VBA?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin G[_2_] Kevin G[_2_] is offline
external usenet poster
  
Posts: 13
Default Convert Chart Series Formula to Array Via VBA?
I am trying to convert the Chart series formula below to an array via VBA. I
have tried recording a macro and have had no success. I used the select
series, click in the formula bar and hit F9 and this does not work.
Can anyone help?

Formula =
"=SERIES(FirstFeltData!R1C65,FirstFeltData!R2C10:R 100C10,FirstFeltData!R2C66
:R100C66,1)"


Reply With QuoteReply With Quote