Simple Code, I think...

[Chronichalt]

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!

 

[Bernie Deitrick]

One of these may do what you want....

If Worksheets("Sheet1").Range("A1").Value = "Bob" Then Worksheets("Sheet1").Printout
If Worksheets("Sheet2").Range("A1").Value = "Bob" Then Worksheets("Sheet2").Printout

HTH,
Bernie
MS Excel MVP