I just found out that this does not work.
For Y = 5 to 1
However this does work.
For Y = 1 to 5
That was all I had to change and my changes to my study worked.
John
For Y = 5 to 1
I checked the syntax and it appears you can work backward if you put in "DownTo".
For Counter = IValue DownTo FValue
Interesting. Learn something every day. It appears the compiler does not do a numeric value check and let my syntax error get buy.
in VBA you can change the increment like this.
For myNum = 16 To 2 Step -2
For Counter = IValue DownTo FValue
Interesting. Learn something every day. It appears the compiler does not do a numeric value check and let my syntax error get buy.
in VBA you can change the increment like this.
For myNum = 16 To 2 Step -2
- Andrew Kirillov
- Posts: 1589
- Joined: 28 Jul 2005
- Has thanked: 2 times
- Been thanked: 31 times
- Contact:
- Andrew Kirillov
- Posts: 1589
- Joined: 28 Jul 2005
- Has thanked: 2 times
- Been thanked: 31 times
- Contact: