Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Macro to populate worksheet tabs
Name: 24HG_Hoop Date: February 28, 2008 at 17:48:27 Pacific OS: XP CPU/Ram: 3800 / 2G Product: clone
Comment:
Hi all,
Can somebody post the code necessary to copy a template tab into X new sheets, and renaming each sheet Test 1, Test 2, to Test X?
Name: Razor2.3 Date: March 2, 2008 at 17:47:50 Pacific
Reply:
Sub a() Dim i As Integer Dim s As Worksheet Set s = Sheets("template") For i = 1 To InputBox("Number of copies?", "NEED INPUT!", 5) s.Copy after:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = "Test " & i Next End Sub
Summary: I am trying to create a macro in an excel workbook that notifies when changes have been made to a sheet. I would like it to notify by email prior to the workbook being saved/closed. The code I have ri...
Summary: I need to know how to populate a Listbox with a TextFile. I have tried ReadLine but it only adds the first line to the Listbox. After adding the TextFile to the Listbox, i need to know how to Edit ...
Summary: 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...
0 
WSH: Delete files in fold...
