| 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! |
| 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) | |||
Threaded Mode
