you have already got the reply in another forum!
try to avoid multiple postings!

-via135


Help with a Formula Wrote:
trying to create a formula that will print a range on another worksheet
within the same workbook if a value in a cell on a different worksheet
is
than 7


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=531209