Md_Hidayat
(Md Hidayat)
1
Hello Everyone,
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)
Regards
Hidayat
Hi @Md_Hidayat ,
We cannot use range value in the write cell activity. instead you can approach it differently like below. please try and let us know. thanks.
- Use write cell activity and input the following expression
Cell → “A” + LastRowColumnA
Text → “100”
- Use Auto fill range activity
Source range → “A” + LastRowColumnA
Fill Range → “A” + LastRowColumnA + 1 + “:A” + LastRowColumnB
1 Like
Md_Hidayat
(Md Hidayat)
3
Thank you @kirankumar.mahanthi1 !
It works as expected.
Looks like auto fill range is the way.
Regards
Hidayat
1 Like
system
(system)
Closed
5
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.