Results 1 to 2 of 2

Thread: Name worksheet with text and variable

  1. Oct 24th, 2006, 06:03 AM #1
    gonzalex
    gonzalex is offline

    Thread Starter
    New Member
    Join Date
    Jun 2006
    Posts
    13

    Name worksheet with text and variable

    Hi,

    I want to name a new worksheet with some text and with the content of a variable, for example i create the worksheet and i want to name it "Product" and the variable "x" content is "3" i want that the sheet name stays like this "Product 3".

    Anyone can help me?
    Reply With Quote Reply With Quote
  2. Oct 24th, 2006, 06:24 AM #2
    lintz
    lintz is offline
    PowerPoster lintz's Avatar
    Join Date
    Mar 2003
    Location
    The 19th Hole
    Posts
    2,697

    Re: Name worksheet with text and variable

    VB Code:
    1. Sheets.Add

    2.     Sheets("Sheet3").Select

    3.     Sheets("Sheet3").Name = "Product " & x
    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


Click Here to Expand Forum to Full Width