WriteCell for Dynamic Column Range

Help Studio
,
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

2

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.

  1. Use write cell activity and input the following expression

Cell → “A” + LastRowColumnA
Text → “100”

  1. Use Auto fill range activity

Source range → “A” + LastRowColumnA
Fill Range → “A” + LastRowColumnA + 1 + “:A” + LastRowColumnB

1 Like
3

Thank you @kirankumar.mahanthi1 !

It works as expected.
Looks like auto fill range is the way.

Regards
Hidayat

1 Like
4

Your welcome @Md_Hidayat

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.