Thread: evaluate a year expression
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Clint Eastwood[_2_] Clint Eastwood[_2_] is offline
external usenet poster
  
Posts: 4
Default evaluate a year expression
What is the proper expression to eval the following formula?? I keep getting
#name? in my spreadsheet.

Thanks

For i = 2007 To 2009


Selection.AutoFilter
Range("F3").Select
ActiveCell.FormulaR1C1 = "=YEAR(RC[-5])=i"

..
..
..
..
next i
Reply With QuoteReply With Quote