Printing a Page Automatically When All Cells are Filled

  • Thread starter Thread starter Gerard Sanchez
  • Start date Start date
G

Gerard Sanchez

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!
 
What you probably need is a worksheet change event. Are there specific
cells that you enter that cause the values to be equal to " "? If so, it
would be useful to know which ones they are.
 
You need to be a bit more precise about the first condition for TRUE. e.g
all cells > 0 or not zero or ?
 
All cells equal to no value, "". Based on an IF formula, i.e.,
IF(B4<>B3,B4-B3,"")

Not zero, just no value at all.
 
It's from a formula that spits out a no value "" , i.e.,
IF(B20<>B21,B20-B21,"")

The formula basically is an error checking for ranges (B20:B53, E:20:E53,
H20:H51), so that the user if notified of any discrepancy whenever there is a
value on these cells (C20:C52, F20:F52, I20:I50).

Let me attache the workbook itself.
 
You sure that user punched values in this range are no value at all?

IF range (B20:B53, E:20:E53, H20:H51)

--

Regards,
Nigel
(e-mail address removed)
 
Not this ranges (B20:B53, E:20:E53, H20:H51)
but ranges (C20:C52, F20:F52, I20:I50).

That second set of ranges contain an IF formula that checks for keypunch
error. If error is found it does simple arithmetic, if no error, it returns
no value.
 
I've sent you the file I am working with. I hope you don't mind.
Maybe you can check it out.
 
Back
Top