Consulting

Results 1 to 4 of 4

Thread: Edit sheetname

  1. 08-04-2005, 02:44 AM #1
    IVY440
    IVY440 is offline
    VBAX Regular
    Joined
    Mar 2005
    Posts
    31
    Location

    Edit sheetname

    Hi everybody, long time no see

    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?
    Reply With Quote Reply With Quote
  2. 08-04-2005, 03:03 AM #2
    Jacob Hilderbrand
    Jacob Hilderbrand is offline
    Site Admin
    Jedi Master         VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Try this.


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



    Reply With Quote Reply With Quote
  3. 08-04-2005, 03:08 AM #3
    IVY440
    IVY440 is offline
    VBAX Regular
    Joined
    Mar 2005
    Posts
    31
    Location
    Thanx DRJ, it's working now
    Reply With Quote Reply With Quote
  4. 08-04-2005, 07:08 AM #4
    Jacob Hilderbrand
    Jacob Hilderbrand is offline
    Site Admin
    Jedi Master     VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    You're Welcome

    Take Care



    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules