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?