I want to update the value of a variable in a for...next loop in a macro. The macro goes through the lines of a specific chart in my document for a single column of the chart. Briefly, the followinh code gives an error because - as far as I understand- it takes the cell value as "text" from the chart and so it can not take the sums. Can anybody help me to find out how can I take the "value" of a cell of the chart?
Regards,
for i = 0 to 'MV_Rowcount-1 MV_Puan = MV_table.getcell(i,6).text MV_Puan = MV_Puan + MV_Puan next
