Error: The range does not exist

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

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

1 Like

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

Hi I have tried that, still got the error.

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

2 Likes

Hi
it works, thanks a lot!

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.