Printing a Page Automatically When All Cells are Filled

[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!

 

[Barb Reinhardt]

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.

 

[Nigel]

You need to be a bit more precise about the first condition for TRUE. e.g
all cells > 0 or not zero or ?

 

[Gerard Sanchez]

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.

 

[geepeeone]

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.

 

[Nigel]

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)

 

[Gerard Sanchez]

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.

 

[Gerard Sanchez]

I've sent you the file I am working with. I hope you don't mind.
Maybe you can check it out.