Answers for "excel vba clear contents and formatting of cell with a single command"

VBA

2

excel vba clear contents and formatting of cell with a single command

'To clear a worksheet range from VBA, use one of
'the 'Clear' methtods:

[A1].Clear           '<-- clears everything in the Range cells
[A1].ClearFormats    '<-- clears only the formats
[A1].ClearContents   '<-- clears values but not formats
[A1].ClearHyperlinks '<-- clears hyperlinks only
[A1].ClearNotes      '<-- clears notes only

Posted by: Guest on May-02-2020

Source

Code answers related to "excel vba clear contents and formatting of cell with a single command"

Code answers related to "VBA"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#