12-15-2023, 01:20 PM
Thanks Ted and all. It was like finding Waldo.
On the multiple uses of the g control variable. I do this often to find a letter with some meaning to the array or formula to which the looping is associated. That way I can search for just that letter if I'm getting questionable results from either a formula or a display of values from an array. I also find that a complicated For/Next loop or IF/ ENDIF seems to be slower than breaking the decision up into smaller multiple loops. And MNRV I'm finding, as long as I run the loop to its end (ie no nesting) I can reuse the same control variable name, like g as many times as I want.
Thanks again for the speedy find of my problem (I'm a slow coded and would have found the solution some time after Christmas) and the explanation of the 7.
Still upset with myself for attaching an image with ads. You guys must have ad blockers because every time I click on the image I uploaded I get flashing ads. I'll have to pay attention to how I did this or no more uploading of those dazzling images of my coding.
On the multiple uses of the g control variable. I do this often to find a letter with some meaning to the array or formula to which the looping is associated. That way I can search for just that letter if I'm getting questionable results from either a formula or a display of values from an array. I also find that a complicated For/Next loop or IF/ ENDIF seems to be slower than breaking the decision up into smaller multiple loops. And MNRV I'm finding, as long as I run the loop to its end (ie no nesting) I can reuse the same control variable name, like g as many times as I want.
Thanks again for the speedy find of my problem (I'm a slow coded and would have found the solution some time after Christmas) and the explanation of the 7.
Still upset with myself for attaching an image with ads. You guys must have ad blockers because every time I click on the image I uploaded I get flashing ads. I'll have to pay attention to how I did this or no more uploading of those dazzling images of my coding.