Thread: Macro Copy Excel Chart Sheet to PowePoint - Mod of Jon Peltier code
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
  
Posts: 5,600
Default Macro Copy Excel Chart Sheet to PowePoint - Mod of Jon Peltier code
You're missing a dot,
change GETFORMULA to GET.FORMULA

Regards,
Peter T

"Frank Hayes" wrote in message
Jon,

I am running into a Run-time error '13': Type mismatch on the sTitle =
ExecuteExcel4Macro("GETFORMULA(""TITLE"")") line. When I debug and hover
over sTitle in the the failed line of code is see ... sTitle = ""
<snip
If .HasTitle Then
' sTitle = .ChartTitle.Text
sTitle = ExecuteExcel4Macro("GETFORMULA(""TITLE"")")
sTitleSize = .ChartTitle.Font.Size
MsgBox sTitle
<snip


Reply With QuoteReply With Quote