I would like to write cell, value = 100 for range A19 to A36, as this range is empty.
Is there a way to define the range to write cell for dynamic start and dynamic end?
I was able to get the last row of column A & B using datable.rows.count and Substring.
Was not able to write range using this formula:
Range Expression in Write Cell:
“$A” + LastRowColumnA + 1 + “:$A” + LastRowColumnB
DyanmicStartEnd.xlsx (10.5 KB)