ST Alpha - "truman, here are those macros." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 158

truman, here are those macros.

Posted by zork Oct 2 '13, 08:47

Sub amanda()
For Each sht In Sheets
With ActiveCell
Selection.FormulaR1C1 = sht.Name
ActiveCell.Offset(1, 0).Select
End With
Next
End Sub

Sub amandaX()
For Each sht In Sheets
With ActiveCell
sht.Name = .Text
ActiveCell.Offset(1, 0).Select
End With
Next
End Sub

Responses:

thanks. -- nm - Truman Oct 2, 08:48

Post a message top

truman, here are those macros.

Replies are disabled on threads older than 7 days.