Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking worksheet names
Have the folowing code hat works, but sheet name may not exsit.
All worksheets with data start with "Sales " and end in a year i.e. "Sales 2005" Need to get first year of worksheets and last year and make the years between first year and last year only valid for years that exsit in workbook. How would I check for worksheet names and get Firstyear and Lastyear? Do SYear = CLng(Application.InputBox(Prompt:="Enter a year between 2005 and 2050", Default:=Year(Date), Type:=1)) ' get start year for report If SYear = 0 Then Exit Sub 'give the user a way out?? Else If SYear = 2005 And SYear <= 2050 Then Exit Do End If End If Loop |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
how to copy workbook names and worksheet names to columns in acces | Excel Programming | |||
Checking names on correct line across sheets | Excel Worksheet Functions | |||
return all worksheet tab names and chart sheet tab names in report - an example | Excel Programming | |||
Checking range names | Excel Programming |