Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to search workbook for NEW worksheet
Here is the situation.
I have a work book that by pushing buttons a macro uses data in th workbook and create a worksheet with that has that data graphed on it I want the macro to first look for the sheet, to make sure that it i not already created before it runs. I am currently using this code: Dim wSht As Worksheet Dim shtName As String shtName = Format(Now, "mmmm_yyyy") For Each wSht In Worksheets If wSht.Name = shtName Then MsgBox "Sheet already exists...Make necessary " & _ "corrections and try again." Exit Sub End If Next wSht to seach through the workbook for different sheets. So when I run th code (and the ws does not exist yet) it works fine. But when I run the macro a second time (and now a sheet already exist with that name) it just comes to the point where the macro names th chart, and stoppes there. and does not error. When I debug the code I can see the "wSht.Name" skip over the new ws. Is there any chance that "Worksheets" does not contain the new w because I have not saved the program yet? please help -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search one worksheet to pull data into another worksheet | Excel Worksheet Functions | |||
I need an Equation in a cell to search a workbook not worksheet | Excel Worksheet Functions | |||
Search a Workbook | Excel Discussion (Misc queries) | |||
Search Data from one Workbook and copy it into another Workbook | Excel Discussion (Misc queries) | |||
Search workbook | Excel Discussion (Misc queries) |