Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recognise filter in macro and ignore.
Hi
Using this community, I have had so much help creating a superb program that creates statements based on information held in a worksheet. The macro inserts a new worksheet and formats the cells etc. The only problem is, some of the values may be zero. Even if we put filters in the source sheet, when we run the statements all the zero records are printed also. Is there a way to add some code where certain fields that hold a zero value are ignored which means that any client who has a zero statement wont get one prinited out? Thanks in advance Malycom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recognise filter in macro and ignore.
If you are moving data to a new worksheet for printing, check the data
before moving it, and skip those records that you do not want to print. If you are moving the data in bulk, then apply a filter to the data on the destination sheet and this hides the rows that you don't want printed. -- Regards, Tom Ogilvy "malycom" wrote in message ... Hi Using this community, I have had so much help creating a superb program that creates statements based on information held in a worksheet. The macro inserts a new worksheet and formats the cells etc. The only problem is, some of the values may be zero. Even if we put filters in the source sheet, when we run the statements all the zero records are printed also. Is there a way to add some code where certain fields that hold a zero value are ignored which means that any client who has a zero statement wont get one prinited out? Thanks in advance Malycom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro ignore formulas | Excel Discussion (Misc queries) | |||
macro - ignore row | Excel Discussion (Misc queries) | |||
Ignore macro run time error | Excel Discussion (Misc queries) | |||
how can I set up a custom filter to ignore the last few digits | Excel Discussion (Misc queries) | |||
Recognise value not formula | Excel Programming |