Differences

This shows you the differences between two versions of the page.

--- en:concepts:djeeniformula [2023/07/26 14:39]
tiger [Last column in a row]
+++ en:concepts:djeeniformula [2023/07/26 14:41] (current)
tiger [Last row in a column]
@@ Line 114: / Line 114: @@
 <code>
   [$wsExample!C[#RowEnd|B]]    'the cell in column C that is next to the last cell in column B
+</code>
+===== Next row in a column =====
+You can find the next row after the last one with data in column A by typing **[#RowNext]**. If you are inside a Djeeni formula extension you may leave [] out and type simply **#RowNext**:
+<code>
+  [$wsExample!C#RowNext]    'the cell in Column C that is in the row of the first empty cell in column A
+</code>
+You can refer to the first row after the last one with data of any column by typing **[#RowNext%%|%%ColumnLetter]**:
+<code>
+  [$wsExample!C[#RowNext|B]]    'the cell in column C that is next to the first empty cell in column B
 </code>