StudioX - Calculate using spreadsheet issue

@Prinal_C - Here you go…

Idea I have used here is : First trying to find the last row of any columns…which gives me the output: 4

  1. Using this value, i can set my range for the column F…

Say : F2: F4

Excel.Sheet(“Sheet1”).Range(“F2:F” + Saved.Values(Of Int32)(“Last Data Row”).ToString)

Here: Saved.Values(Of Int32)(“Last Data Row”).ToString) ==> has the value of 4…

  1. In the what to write = I am giving the formula as E2*2.5

That’s it here is my output

image

2 Likes