Clear

Home Search Site Map

Up
Clear
Copy
Cut
Delete...
Delete Sheet
Fill
Find...
Go To...
Links...
Move or Copy Sheet...
Object
Office Clipboard...
Paste
Paste as Hyperlink
Paste Special...
Redo
Replace...
Undo

New! Excel User Group Now Open @ www.excelusergroup.org, Check It Out!


Menu command Type What happens next?
Clear

Sub menu has four options, (Shown Left) allowing you to clear All, Formats, Contents, Comments. This option purely clears the data. In Excel, a clear is not the same as delete. Delete moves the data and the cells around it, clear does nothing with the cells it purely changes (removes) the contents or formats. You should pre-select your data before taking these options.

Sub ClearData()
'Example shows contents, could also be e.g. ClearFormats
Range("A1:A100").ClearContents
End Subub

Copyright Nick Hodge 2008. All Rights Reserved.