Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart macro

Hello,

I use macro to get date from chart:

sub qqqq


set obj = ActiveDocument.GetSheetObject( "CH03" )
CellRect = ActiveDocument.GetApplication().GetEmptyRect()
CellRect.Top = 0
CellRect.Left = 0
CellRect.Width = obj.GetColumnCount
CellRect.Height = obj.GetRowCount
set CellMatrix = obj.GetCells( CellRect )
for RowIter=CellRect.Top to CellRect.Height-1
    for ColIter=CellRect.Left to CellRect.Width-1
        msgbox(CellMatrix(RowIter)(ColIter).Text)
    next
next


end sub

How could I get max Column value into variable in this macro?

0 Replies