I'm trying to record a macro but I'm having difficulty with a particular
action.
I'm trying to copy text from a particular cell, Lets say Cell A1, and then
go to the "Sheet Tabs", currently labeled Sheet 1, and paste the text to
rename the sheet.
Can Someone tell me what I'm missing from the following macro to make this
happen:
Sub Macro()
'
' Macro Macro
' Macro recorded 8/18/2005 by Anthony Amato
'
'
Range("A1").Select
Selection.Copy
Sheets("Sheet 1").Select
Sheets("Sheet 1").Name = " " (Should I add paste here? and how)
Range("B17").Select
End Sub
Any help would be greatly appreciated.
Bookmarks