OK i have a formula that pulls from two different sheets. If one of the
sheets is not there I get the #REF! error which i get why. Where im stuck is
which ever sheet is not there i need to adjust the formula so that it will
then only pull from the one sheet. I just cant think of how to do this in
code.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200707/1