Friday, 31 August 2012

Macro To Count No.Of Rows And Columns Selected In A Active Sheet

Macro To Count No.Of Rows And Columns Selected  In A Active Sheet

Sub Count1()
Dim Count1, Count2 As Variant
Count1 = Selection.Rows.COUNT
Count2 = Selection.Columns.COUNT
MsgBox ("No.of Rows = ") & Count1 & vbCrLf & ("No.of Coloumns = ") & Count2 & vbCrLf & ("Existed In The Current Selection ")

End Sub

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts