Friday, 31 August 2012

Macro To Know The Available Worksheet Names In A Active Work Book

Macro To Know The Available Worksheet Names In A  Active Work Book

Sub ShowWorkSheets()
Dim x As Worksheet
For Each x In Worksheets
MsgBox ("The Available Worksheets In This Workbook Are :") & vbCrLf & x.Name
Next x
End Sub

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts