Based new sheet names on cell value

J.W. Aldridge

Guest

Posts: n/a

24th Jun 2009

Private Sub Workbook_NewSheet

Need each sheet name to have same prefix then end with cell value.

Prefix: "Jeremy "

Suffix: Value in cell e2: 6/23/2009

For end result, subtract one from date given in e2.

End Result: Jeremy Mon 6-22

« Excel Macro to delete between 2 defined points | Complie error: Expected: end of statement »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy rows from one Data sheet to another sheet based on cell conte	John McKeon	Microsoft Excel Misc	2	15th May 2010 06:49 AM
Change sheet names based on cell contents	Jim G	Microsoft Excel Programming	6	19th Jun 2009 11:47 AM
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet.	bertbarndoor	Microsoft Excel Programming	4	5th Oct 2007 04:00 PM
hyperlink to sheet name where sheet names=cell content	Banzai	Microsoft Excel Programming	1	6th Aug 2007 12:46 PM
Excel VBA (?!)-refer to a cell on Sheet to left of X, based on criteria on Sheet X	tempjones	Microsoft Excel Programming	2	7th Jun 2004 09:48 PM