How to Reference a Loop Counter

[Bensley]

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

Please Login or Register  to view this content.

It will tell me what loop it is up to, so i know that it is certainly increasing numbers


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

[xlnitwit]

Hi,
You can simply pass the number as an argument

Please Login or Register  to view this content.

I have highlighted the required changes. You would need to amend any other routines that use the variable too; or you could use a public or module level variable.

[Bensley]

Not sure that will work with the overall code, I have changed the documents so that as longs as they are in the same folder they will work


the code in question is under practices lists on the sheet interface, and is the "add to database" button, you don't need to open the database, it will auto do that
i just had the extra button there so i could open it quick for editing


the button asks for what practice list so you will need to choose '1' as there is only one, and then the date, enter what ever in date format, then will try to put
the data on the database, but will fail. due to not referencing the counter



i originally had another loop in there it was dodgey it is just in comments right now, i don't like using select and copy and all that


Thanks

Bensley