By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

 


Clear

Method to to Clear data from a cell or cell with a number of options
  • all
  • formats
  • contents
  • comments
  • hyperlinks

    Warning: From VBA code this can't be undone. If you clear the data it's gone unless you write VBA code to save it.

    Examples
  • Range("A1").clear
  • Range("A1:B2").ClearContents
  • Range("B:B").ClearFormats


    • blog comments powered by Disqus