View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gerard Sanchez Gerard Sanchez is offline
external usenet poster
 
Posts: 46
Default Printing a Page Automatically When All Cells are Filled

Hi,

'I was wondering if anybody can help me write this in VBA:

IF range (B20:B53, E:20:E53, H20:H51) manually user keypunched values,

AND range (C20:C52, F20:F52, I20:I50) equal to = " " -- calculated by
formula that spits out values only when there are discrepancies with the
manually keypunched values above,

THEN batch02. I have already created macros assigned to user buttons that
prints assigned ranges for each batch. For this case, its batch02 macro.


'Thanks
'Appreciate the help!