Dynamic Cell Reference

Dynamic Cell Reference

I have an Excel application that I'm trying to emulate in Creator. A simplification of use-case is described below:

The Excel application iterates down a column and examines the values of each cell. Depending on the value, it adds to adjacent cells in the columns before and after the current column.

Take note of the yellow cell and the code below. Since the cell's value is 5, it adds the two adjacent cells highlighted in green. Since Creator does not have cell references, I do not see a simple way to emulate this. Additionally, the Excel code is efficient because the cell variables are also dynamic, something we cannot do in Creator.


  1. Column = 4
  2. For Row = 1 To 15
  3.     If Cells(Row, Column) = 5 Then
  4.         Cells(Row, Column) = Cells(Row - 1, Column - 1) + Cells(Row + 1, Column + 1)
  5.     End If
  6. Next Row
Thanks in advance for any ideas.

John M. Whitney
Recommend