Thank you Cory,
Not sure if I fully understand how I will actully convert what you suggest to a Express Macro
I kinda get that I could capture the text in the formula bar ... and then test for a IF contains =sum
but, not sure how to do that in Express Macro. sorry.
On the blanks ... on a row of numbers ... there will be blanks and maybe zeros ... before a =sum is hit (at the end).
* doing this with a IF "=sum" END repeat ... would be the most elegant Stop.
Right now I am doing it with a ... countA ... to get how many numbers are in the row ... and then having Express macro do the window pop up to ask the number of repeats ... which is not as automated. or as fast.
Thank you,
HG