Posted to microsoft.public.excel.programming

Clint Eastwood[_2_] Clint Eastwood[_2_] is offline

external usenet poster

Posts: 4

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
evaluate a concatenate expression	Russell.Ivory[_2_]	Excel Worksheet Functions	3	November 4th 09 05:52 PM
Combination Graph with current year and prior year sales	JanW	Charts and Charting in Excel	2	April 5th 07 09:20 PM
trying to get day/month/year froamt while user enters year only	RADIOOZ	New Users to Excel	3	June 7th 06 05:30 AM
Evaluate Custom Expression	Peter	Excel Programming	7	April 3rd 06 01:18 PM
How to evaluate a text expression as formula ?	Krzysztof Klimczak	Excel Programming	0	August 29th 03 04:31 PM

All times are GMT +1. The time now is 11:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us