Write number in a in a sequence Range excel

Hello Friends,

I want to insert a range in sequence of numbers…

image

How can I do this, whithout to use for each ?

Thanks!!

Hi @Diego_Pin
Check this


Hope it helps :slight_smile:

2 Likes

@Diego_Pin Hello,

You must use for each but if you already have the info in a data table or if you want to add data to a data table use any of this 2 depending if you want to add a column or row.
image
Then just use write range to access the excel/workbook just once:
image .

If you do not want to use For Each loop, then use the following -

Write Cell activity - Write a formula into a range

Formula = Row() - 1

Row() function returns the row number.
For example, for A2 row, Row() returns 2.

Regards,
Karthik Byggari

1 Like

Hello @KarthikByggari, Can you give a example in image pls?

You can use Auto Fill Range Activities.

Try to adapt this post into your work.

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