Friday, 31 August 2012

Excel VBA Macro to Clear Contents,Formats of an Active Work Sheet

Macro to Clear Contents,Formats of an Active Work Sheet 
--------------------------------------------------------------------------------------
Example-I: 

Sub Clear_Contents()

'Removes only the cell contents

Range("A1:Z1000").ClearContents

End Sub
--------------------------------------------------------------------------------------
Example-II: 
Sub Clear_All()
'To Remove cell contents & their formats
Range("A1:Z1000").Clear

End Sub



3 comments:

  1. It's going to be end of mine day, except before end I am reading this wonderful post to
    increase my know-how.

    ReplyDelete
  2. Hi mates, good post and nice arguments commented here, I am actually enjoying by these.

    ReplyDelete
  3. Awesome article.

    ReplyDelete

Hi User, Thank You for visiting My Blog. Please post your open Feedback only related to this Blog Posts. Please note that I cannot respond to the Anonymous Comments.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts