Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rename a worksheet to a cell name and text

Status
Not open for further replies.
RyanScharfy

RyanScharfy

Technical User
Jun 17, 2003
86
0
0
US
I'm trying to rename a worksheet but keep getting a trailing quotation mark

Sheets("YTD Budget Detail").Name = Sheets("YTD Budget Detail").Range("A7") & " Blossom"" "

Gives me: Yellow Blossom"

I'd like it to read: Yellow Blossom
 
Sort by date Sort by votes
I am retarded. This works. For posterity:

Sheets("YTD Budget Detail").Name = Sheets("YTD Budget Detail").Range("A7") & " Blossom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Question
Outlook Template replace text 2
Replies
13
Views
933
Andrzejek
Andrzejek
M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
132
mintjulep
M
K
  • Question
How to resolve define worksheets array
Replies
1
Views
165
combo
combo
arvarr
  • Locked
  • Question
Rename Connection Name (Data Connection) 2
Replies
4
Views
101
arvarr
arvarr
feipezi
  • Locked
  • Question
How to make a recorded Excel macro (convert a text file to a Workbook) more efficient?
Replies
11
Views
163
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top