How to Copy paste same value in all rows of same column?

How to write the same value to all rows to particular range… With out write cell… as it takes a long time


You can use “Build Data Table” and “Add Data Row” activity.

Just create a Data Table By using “Build Data Table” and add rows by using “Add Data Row” activity.
After adding all rows, use “Write Range” activity to write values to a particular range.


idk if its safe, but one way without looping


1 Like

Hi @vvaidya,

I get the error as A column named ‘XYZ’ already belongs to this DataTable.
How can I add same column value to multiple rows?