Write Cell: The range does not exist

cristian_urrego · June 3, 2020, 2:22pm

Hello team I have an error with a formula in Excel, I am doing it this way

This is generating this “Write Cell: The range does not exist.” Error. thank you very much for your help

Anthony_Humphries · June 3, 2020, 2:23pm

You need a number after your range, like “HK2:HK20”, or you can specify the entire column with “HK:HK”.

cristian_urrego · June 3, 2020, 2:27pm

Hello, thank you for your answer, if I have it that way, I think the error is generated in the formula, but I don’t know why.

Anthony_Humphries · June 3, 2020, 2:28pm

The range error only refers to the Range field for Write Cell. Are you getting a different error now?

cristian_urrego · June 3, 2020, 2:39pm

I generated this

But when I remove the formula and enter for example test it does not generate that error

Anthony_Humphries · June 3, 2020, 2:46pm

What if you change the Range to “HK1”?

cristian_urrego · June 3, 2020, 2:48pm

The same mistake

bcorrea · June 3, 2020, 2:55pm

Try to change the semi columns for commas in the parameter separators in your formula.

cristian_urrego · June 3, 2020, 3:04pm

Thank you very much it worked

system · June 6, 2020, 3:05pm

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