My cell range is "E4:AJ4". These cells are either blank or have a "1" in them. I need to be able to count from "E4" until the first "1" is read and I need to display this value. If there is a "1" in "E4" I need to display a "0"; If there is a "1" in "J4" I need to display a "5"; etc. My programming is not strong and I have not been able to find examples close enough to meke this work. Any help would be appriciated.
Thanks
Jack
Thanks
Jack