This code adds a new worksheet. If you leave it as is it will just add the next sheet in the count…if you run in and you have three sheets, it will add sheet 4. Dim WS As WorksheetSet WS = Sheets.Add
Seminar Info: Random Links of Goodness:· Save time on importing with Excel by using the smart tag. http://www.alsde.edu/html/EdDirToTextSchool.asp· Good Info from Ozgrid http://www.ozgrid.com/Excel/excel-faq.htm· Generate unique random numbers http://www.ozgrid.com/VBA/RandomNumbers.htm· Working with Worksheets http://www.ozgrid.com/VBA/working-with-worksheets.htm· Working with Dates and Times in an Excel http://www.ozgrid.com/Excel/dates-times.htm· 10 ways to reference Excel workbooks and sheets using VBA http://blogs.techrepublic.com.com/10things/?p=967 Macros that you […]
Recent Comments