Friday, 31 August 2012

Excel VBA Macro To Clear Contents,Formats Of A Active Work Sheet

Macro To Clear Contents,Formats Of A 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



No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts