Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Using VB to rename Excel sheet tabs

Comment:

In Excel i want to rename the worksheet tab using a VB macro. I want it to copy a cell on the worksheet and use it as the worksheet name. It needs to be variable because i want to copy the worksheet, increment the cell value by one, and have the new worksheet named the new cell value. Here is the code: ActiveSheet.Copy After:=ActiveSheet ActiveSheet.Previous.Select Range("j3").Copy ActiveSheet.Next.Select Range("j3").PasteSpecial xlPasteValues Range("j3").Value = Range("j3").Value + 1 ActiveSheet.Name = Range("j3").Value It is the last line that is giving me trouble. Thanks for any help.

Name: egkenny
Date: March 28, 2003 at 17:13:15 Pacific

Reply:

ActiveSheet.Name = Format(Range("j3").Value, "#")

0

Reply:

It worked perfectly, I did change the format to mm-dd-yy. Thank you egkenny!

0

Help with a piece of code...

I know it's a Programming...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I am looking for a VB Script that would rename several Acrobat files based on a reference list (txt, csv, ect). The acrobat files are created with time/date stamp. I would like a vbs to rename those ...

Summary: i am using visual basic 6 (not visual basic script or VBA) and i wrote a program that writes texts to an excel sheet.I need to make these texts hyperlinks to a path that i will provide (variable in th...

Summary: Can anyone tell me the specific code for setting a hyperlink to a specific sheet in a excel worksheet. I am trying to set it up so that different links take the user to a different sheet in the same s...