Thread: Excel VBA macro - need to edit code to skip a year
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
adun3434 adun3434 is offline
external usenet poster
  
Posts: 1
Default 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 With QuoteReply With Quote