PDA

View Full Version : [SOLVED] Edit sheetname



IVY440
08-04-2005, 02:44 AM
Hi everybody, long time no see :hi:

I have another question.

How can I change the name of my sheet with 2 strings which are in A1 and A2.

I tried with:

Activesheet.Name= A2 & " - " & A1

But then it only returns - in my sheet name.
Can anybody help me?:bow:

Jacob Hilderbrand
08-04-2005, 03:03 AM
Try this.



ActiveSheet.Name = Range("A2").Text & " - " & Range("A1").Text

IVY440
08-04-2005, 03:08 AM
Thanx DRJ, it's working now

Jacob Hilderbrand
08-04-2005, 07:08 AM
You're Welcome :beerchug:

Take Care