I’m trying to copy a column and paste + transpose at the same time, when the source is:
error would occur, so I tried a range here:
The problem is the ‘76’ in this expression would change every time, so I would like to use a variable to replace it.
Wondering how should the variable be inserted in the expression below:
Please try this
Excel.Sheet("Sheet2").Range("A1:A" + Variabletoabeinserted)
you can try as mentioned the below
here rowCounter is an integer value which holds the row value of the last row.
Hi @Sharath_HK ,
Can we use an activity in Studio to get the rowCounter? Cause when I tried to use in directly, it shows the variable is not declared. Thank you.
You could use the “Find First/Last Data Row” activity to get the last row in a column.
Hi @Anil_G ,
Thank you, it’s working with some followup adjustments.
Hi @yikwen.goo ,
Thank you for your answer, it’s working!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.