Error: The range does not exist

Help
, ,
1

Hi ALL

I am working on an existing data table, I need to change some value of this data table and then write it to a excel sheet.

However, after I use for each to change the value, when I write range, it always said error: the range does not exist.

This is my code, inside of Excel Application Scope

image
image585×753 15.7 KB

this is the error message

image

Also, I have tried to comment out he for each part, then it can write correctly. but with this part, it will show error message.

Thanks
Jing

2

Can you print the data on a different sheet and see if you are still getting the error

3

Hi I have tried that, still got the error.

4

Use write range outside of Excel scope and use write range workbook activity and try to print in a completely new sheet

5

Hi
it works, thanks a lot!

I just confused, how could excel application scope not work then the workbook one can work, so weird.