Next empty column

Hi all,

I’m looking to copy cell A1 to paste on the first empty column of row 4.
Currently it is at column JL but this empty column will change.

I have read cell A1 and define it. Can I confirm how do i write this to the next empty column of row 4? Thanks!


Use Read Range activity and declare a variable for Datatable

Now you can declare a variable for count and write as Datatable.Rows.Count

This will give you the rows count then you can decide where you want to write you results

Hope this may help you


Hello @victorialim

You can write as below to get the first free column index. Using that you can write to the first free column.


Hi @victorialim,

In step 1, it is necessary to dynamically find the letter.

Then you can use this in step 2.