Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Button Macro with Multiple Conditions
Hi,
'Here is what I am trying to do: Sub PrintWithConditions() If Range("G59") = "Select Customer" And _ Range("F64") = "Select User" And _ Range("F65") = "Not Balanced !" And _ Count(Range(C61,C62,F61,F62,I61,I62) 0 < 2 Then MsgBox "Required information not filled and/or Discrepancy exists!" Else Range("A18:I69").PrintOut Copies:=1 End If End Sub 'For ranges C61,C62,F61,F62,I61,I62, I just want one (1) of these cells with a value 'I am working on a worksheets that have 25 pages and that 'hopefully if I can get this right, I can just change the range values and assign it to 'other buttons on separate pages of the same worksheet. 'Can anyone help me on this ?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set up a command button to print multiple workbook | Excel Discussion (Misc queries) | |||
print button macro & specific tabs to print | Excel Worksheet Functions | |||
Print Button Macro | Excel Programming | |||
Create command button to print multiple worksheets in a excel file | Excel Discussion (Misc queries) | |||
Make button to print Multiple occurences of item based on input | Excel Programming |