Hey everyone,
I want to reference a loop in other functions because depending on the loop count it is up to depends on the row i want.
Please Login or Register to view this content.
Please Login or Register to view this content.
I can't give a worksheet for this one as it is entangled with a database and would break the moment i removed it.
pretty much if i go
It will tell me what loop it is up to, so i know that it is certainly increasing numbersPlease Login or Register to view this content.
But i can't reference it
The moment i do
Please Login or Register to view this content.
If i hover over CurrentActiveRow i get [Empty] and if i hover over CounterCar i get [1] or what ever loop it is up to
I did have a code before this using select, it worked at first but i found it unreliable and just my computer dropping in speed could trip it up, if you have a better way of doing this i am open to ideas, i don't want to use select, speed is key but most important reliablity
If you need more information i will do my best to provide
Thanks
Bensley
Bookmarks