View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gerard Sanchez Gerard Sanchez is offline
external usenet poster
 
Posts: 46
Default Need Help writing Print Macro

Hi,

I'd like a print macro to print range A18:I69 only IF:

IF -- G59 < "Select Customer from Dropdown List"
IF--- F64 < "Select User from Dropdown List"
IF--- E65 < "Not Balanced !"

IF all conditions above are not met:

Message Box:

"Batch will not print until all discrepancies have been settled
and required information filled."

Appreciate any help.


Thanks!