i have a problem with my excel application scope, in which i wanna write a formula in a specific cell.
the following screenshot shows my current activity:
(Sheet1 is a variable)
I have to questions and i would be very greatful, if you could answer them:
Why do i always get the exception: The range does not exist?
Which activity do i need to implement next to expand this formula for every other row, where it can find data in column A?
you can do it based on write value activity within excel application scope activity and pass the cell as "B13:B+Dt.Rows.Counts.ToString range and give the formula