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

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts