There is an error when I use clear range for excel

Hi,
Is there anyone know how to write the expression editor when I try to use clear range to clear data of column A and B but there is an error as attached scrrenshot. Thanks.

Hi @Evelyn_Lu

Try to enclose the range in " ". Like this - “A:B”

Hope this helps,
Best Regards.

Follow below steps
1.


2. CLick on custom input and the provide your range (ex: A1:B10) and worksheet name
image

Hi @Evelyn_Lu ,

For your reference:

image

Regards,

1 Like

Hi All, Thank you so much!

1 Like

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