| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing a Page Automatically When All Cells are Filled
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing a Page Automatically When All Cells are Filled
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! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing a Page Automatically When All Cells are Filled
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. "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! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing a Page Automatically When All Cells are Filled
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! |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing a Page Automatically When All Cells are Filled
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. "Gerard Sanchez" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| printing only filled in cells of an inventory? | Excel Discussion (Misc queries) | |||
| How to stop printing untill certain cells are filled in? | Excel Discussion (Misc queries) | |||
| Printing Frozen Cells Automatically on every page | Excel Discussion (Misc queries) | |||
| I need formula that will automatically count the filled cells. | Excel Discussion (Misc queries) | |||
| Macro that copy page to page just some filled cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
