Friday, 31 August 2012

Macro To Add Column Headings As Worksheets

Macro To Add Column Headings As Worksheets

Sub MAC4()
Dim x As Integer

For x = 1 To 5
Sheets.ADD.Name = Sheets("AAA").Cells(1, x)
Next x

End Sub

No comments:

Post a Comment

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