P112 Clear Cell Contents of a Worksheet

/P#

Meaning

Extra Parameters: /1{Parameter1} … /n{Nth Parameter}

112

Clear Cell Contents of a Worksheet

/1 = lWhatToClear

0 = Clear ALL 

1 = Clear FORMATS 

2 = Clear CONTENTS 

3 = Clear COMMENTS 

4 = Clear NOTES 

5 = Clear OUTLINE 

/2 = sSheetStart (by name or number)

/3 = sRange (leave blank for ‘used range’)

 

This special process can clear the contents that you specify in the range that you specify.

Special Parameters Described in Detail

/1{lWhatToClear} Clear some or all of the cells contents.

0 = Clear ALL 

1 = Clear FORMATS 

2 = Clear CONTENTS 

3 = Clear COMMENTS 

4 = Clear NOTES 

5 = Clear OUTLINE 

/2{sSheetStart} Name of the sheet to alter. Required.

/3{sRange} Range of cells being cleared (i.e. “A1:B4, J10”). Leave empty for ‘used range’.

 

Examples:

EXAMPLE 1: Clear Formats within a specific range of cells