| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA macro - need to edit code to skip a year
I need to edit a piece of code in a VBA macro to make it look for
specific year within two different ranges. I currently have: Case "12391" sDesc = "SOUTH CAROLINA" sYear = "1970" fYear = "2000" Case "12401" sDesc = "SOUTH DAKOTA" sYear = "1970" fYear = CStr(Year(Now)) I need to skip 2001-2002 and have it continue looking for 2003 t present for "SOUTH CAROLINA" only. In other words, the range for Sout Carolina would be 1970 thru 2000 and 2002 thru present. Thank you in advance for your assistance. Angel -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I view and edit the source code for a Chart in Excel 2003? | Charts and Charting in Excel | |||
| How can I edit the year in a date field in Excel? | Excel Worksheet Functions | |||
| Edit this macro code to loop and end | Excel Discussion (Misc queries) | |||
| skip code | Excel Programming | |||
| Excel skip some lines of VBA code | Excel Programming | |||
Hybrid Mode
