What is the syntax to clear a range?

Range(“<your range>”).Clear
'examples
Range(“D:D”).Clear ‘clears column D
Range(“A2:C5”).Clear ‘clears range A2:C5
Range(“B1:B3”, “D1:E5”).Clear ‘clears multiple ranges

 

Advertisements