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


"Nigel" wrote in message
...
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




"Gerard Sanchez" wrote in message
...
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.


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


--

Regards,
Nigel




"Gerard Sanchez" wrote in message
...
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!