I also solved using a named range with an Offset and count formula in it. thank you though.