Function to step through an array only once per call.

[Dragondude]

Hi all.

Not sure if this can be done or not but here goes.

I have a variable in a macro that needs to be incremented from an array inside a For/Next loop. The For/Next loop steps through 30 times, once per chart update. I also need to update a variable from an array. The array contains a set of numbers relating to rows on worksheets.

I am not sure how to go about doing this. I have the For/next loop working fine now but I can't get the variable to only update once per loop.

Here is what I have so far. I have started to put the array inside a function, may or may not be the way to go.

Please Login or Register  to view this content.

Here is where it is called from.

Please Login or Register  to view this content.

[mehmetcik]

As far as I can see this code would do nothing other than return an error.

You have a For without a next
You have not set SetRowNum to anything

Please Login or Register  to view this content.

[Dragondude]

I realise the lack of next. I know if I put the next in it Will just loop and do nothing. I actually worked it out another way. I will post my code on Monday when I am back at work.

As far as I can see this code would do nothing other than return an error.

You have a For without a next
You have not set SetRowNum to anything

Please Login or Register  to view this content.

[Dragondude]

Here is what I have come up with that works....for now. I still want to do a few tweaks.

Please Login or Register  to view this content.

[mjr veverka]

... I have a variable in a macro that needs to be incremented from an array inside a For/Next loop. ...

? Which one variable is it ?

[Dragondude]

Originally "b" was the for next loop and "d" needed to step through the array arr1 for each "b". I swapped them around and now it works a charm. It could possibly do with some cleaning up but my learning curve is very steep at the moment. I have managed to reduce about 4000 lines of code down to a couple of hundred. My brain now really hurts. I have attached the complete code below as is won't let me post the code..

[mehmetcik]

I am sure that there is an error in your functions.

Please Login or Register  to view this content.

[Dragondude]

Good pick up. I had it that way so I knew what I was trying to achieve. I knew it needed cleaning up. Its all a big learning process.

Thank you