6 Replies Latest reply: Feb 24, 2016 12:37 AM by jagan mohan rao appala RSS

    Macro can it be able to replace by other ?

    PAUL YEO

      Hi All

       

      How to replace below macro to not using macro:-

       

      sub CR01()

       

       

      set chart = ActiveDocument.GetSheetObject("CH1")

      set p = chart.GetProperties

      set NoColumns = ActiveDocument.Variables("vNoOfColumns")

      set NoRows = ActiveDocument.Variables("vNoOfRows")

       

       

          p.ChartProperties.TrellisProperties.Columns= NoColumns.GetContent.String

          p.ChartProperties.TrellisProperties.Rows= NoRows.GetContent.String

          chart.SetProperties p

       

       

      end sub