ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   for each...next in reverse (https://www.excelbanter.com/excel-programming/313267-each-next-reverse.html)

Rod Jones[_3_]

for each...next in reverse
 
Is it possible to do a reverse for each..next loop .e.g

Dim grCell as range

for each grCell in range("A100:A1") ' loop bottom to top
...do something here
next grCell

Any ideas
Thank you for your time.


Myrna Larson

for each...next in reverse
 
You got about 3 replies to your first post. No need to post twice more.

On Tue, 12 Oct 2004 06:53:04 -0700, Rod Jones
wrote:

Is it possible to do a reverse for each..next loop .e.g

Dim grCell as range

for each grCell in range("A100:A1") ' loop bottom to top
..do something here
next grCell

Any ideas
Thank you for your time.



Rod Jones[_3_]

for each...next in reverse
 
Quite right, I have had three replies, but my first two posts attampts came
up with an error prompting me to try again later, so, thats what I did, only
for them to appear later.

"Myrna Larson" wrote:

You got about 3 replies to your first post. No need to post twice more.

On Tue, 12 Oct 2004 06:53:04 -0700, Rod Jones
wrote:

Is it possible to do a reverse for each..next loop .e.g

Dim grCell as range

for each grCell in range("A100:A1") ' loop bottom to top
..do something here
next grCell

Any ideas
Thank you for your time.





All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com