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 ?

    Yeo Poh sai

      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