Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple Code, I think...
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple Code, I think...
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 wrote in message oups.com... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Checkbox Message Code | Excel Discussion (Misc queries) | |||
code not unique find latest date | Excel Discussion (Misc queries) | |||
VLOOKUP for Zip Code Ranges | Excel Worksheet Functions | |||
Conform a total to a list of results? | Excel Discussion (Misc queries) | |||
Macro for changing text to Proper Case | Excel Worksheet Functions |