EXCEL Clear a cell / range’s validation function

This article describes the RPA Excel functionality to clear a cell / range’s validation.

For a full list of available functions, please read EXCEL functions.

Description

The EXCEL Clear a cell / range’s validation function allows you to clear a cell / range’s validation.

Setting it up

To use the EXCEL Clear a cell / range’s validation function, follow these instructions:

{{popups:rpas/add:action=excel-validation-clear}}

Once on a process map:

1. Navigate to the process where you would like to add the EXCEL Clear a cell / range’s validation function
2. Click on the green button’s drop-down (right side of the green button labelled “Process”)
3. On the menu that appears, click on the “+ Activity” item
4. From here you can select the EXCEL Clear a cell / range’s validation option
5. Click "Add" once you are done

Input parameters

Output variables

This action does not produce output variables.

Errors

Tips

• Removes data validation rules from the specified cells

Related functions

• excel-validation-set
• excel-validation-get