Auto Fill in whole column

Question

Hello guys,

I’m trying to automate a process in which I have a formula in the cell “E2” (simple sum of C2+D2). Now I want to apply the formula on the whole column E. I tried to read out my table and store it in a variable. Then I used the “Rows.Count” function to count to the last row which is in my table as you can see in the screenshot. When i execute the robot it says: “Excel Application Scope: Object reference not set to an instance of an object.”
Can somebody help me?

Best regards

Answer 1

Hi, will tell you a method without using for each which can be used in any formula like we do drag drop in excel manually.

Use write cell. In the cell property use "E2: E".Trimend+(<your data table>. Rows.Count+1).tostring.(since your requirement starts from 2nd row here E2. IF from the first row only rows. Count)

In formula use the same,

"=sum(C2+D2)".

Confirm once it worked.

Comments

It worked! Thank you very much :)