Using Variable in For .. Next

[#1]

Ho Guys

I have declared the Variable in the Back End Like Below:

Let _vYear = '=Year(Max(Today()))';

Now i want to use the above variable in my For Next statment :

For i = 2005 to $(_vYear)

-

-

-

Next

But it is not  working ....

Is there any other way to achieve the above :::::

[alexandros17]

Let _vYear = Year(Today());

For i = 2005 to $(_vYear)

...


Next

hope it helps

[hic]

You don't even need the $-expansion. The following should also work:

Let _vYear = Year(Today());

For i = 2005 to _vYear

   ...

Next i

HIC

[#4]

try this

Let _vYear = Year(Today());

For i = 2005 to $(_vYear)

...


Next   i