I want to look through a range of cells (A1:z1) and if any one of the cells
is not blank I would like to return a 1.

Thanks
Ron