so I copied your fomula into word did a find and replaced on the word "filled" and replaced it with "open" to try to make it work for the other worksheet and I got an error... any thoughts?