I can't seem to do a standard Print IF when the IF references a formula
(Probably because I need something a little more complitcated?) Let's
say (Sheet2)A1= (Sheet1)A1, (Sheet1)A1=Bob. I know I can just call a
macro to Print Sheet 2 if (Sheet1)A1=Bob, but can I Print
If(Sheet2)A1=Bob? I don't really know how to write it out if this
doesn't make any sense, but when I reference a cell containing a
formula, I cant reference the value of the formula (Wether It's Bob,
Joe, Sue, etc...), that or I just don't know how......... (<----Most
Likely...)

Thanks for the help!