Friday, 31 August 2012

Macro To Delete Selected Cells , Rows, Columns In A Active Work Sheet


Macro To Delete Selected Cells , Rows, Columns In A Active Work Sheet 


Sub Delete1( )
Selection.Delete                     'Deletes Selected Cells'
End Sub

Sub Delete2( )
rows(1).select
selection.EntireRow.Delete  ''Deletes Entire Row'
End Sub

Sub Delete2( )
columns(2).select
selection.EntireColumn.Delete  ''Deletes Entire Column'
End Sub




No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts