Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :::::
Let _vYear = Year(Today());
For i = 2005 to $(_vYear)
...
Next
hope it helps
You don't even need the $-expansion. The following should also work:
Let _vYear = Year(Today());
For i = 2005 to _vYear
...
Next i
HIC
try this
Let _vYear = Year(Today());
For i = 2005 to $(_vYear)
...
Next i