There is an error when I use clear range for excel

[Evelyn_Lu]

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.

[arjunshenoy]

Hi @Evelyn_Lu

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

Hope this helps,
Best Regards.

[Dilip_Wakdikar_1996 (Dilip Wakdikar)]

Follow below steps
1.

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

[vishal.kp (vishal)]

Hi @Evelyn_Lu ,

For your reference:

Regards,

[Evelyn_Lu]

Hi All, Thank you so much!